Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!feeder.news-service.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Robert Klemme Newsgroups: comp.lang.java.programmer Subject: Re: SQL Puzzle - too many dimensions Date: Mon, 09 May 2011 22:10:52 +0200 Lines: 23 Message-ID: <92r02mF24dU1@mid.individual.net> References: <3Boxp.9547$HF3.5013@newsfe03.iad> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net bwzdpLdSWJl2t5zfarSHfQvpZXi1aifjm2I2ty27KG3W63d6A= Cancel-Lock: sha1:v6jGjE7Kz6b7TIHpujBpH6WIZko= User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.17) Gecko/20110414 Lightning/1.0b2 Thunderbird/3.1.10 In-Reply-To: X-Antivirus: avast! (VPS 110509-1, 09.05.2011), Outbound message X-Antivirus-Status: Clean Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.programmer:3874 On 09.05.2011 01:06, Zapanaz wrote: > On Sun, 08 May 2011 01:02:00 -0300, Arved Sandstrom > wrote: > >> select > >>from ( >> select song_key, max(rating) max_rating >> from songs group by song_key >> ) mx > > ah I didn't think of that. I don't think I've ever used a subquery as > a table like that before. Thanks very much. That's called an "inline view". Cheers robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/