subject:"\[SQL\] Help with sub query"

Re: [SQL] Help with sub query

2007-03-18 Thread Phillip Smith

Add something like this to your query: ORDER BY price_time LIMIT 1 Cheers, ~p -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roopa perumalraja Sent: Monday, 19 March 2007 13:56 To: pgsql-sql@postgresql.org Subject: [SQL] Help with sub query

[SQL] Help with sub query

2007-03-18 Thread roopa perumalraja

Hi all, I want the last value from the group of rows. The table 'index_prices' is index_code price_time price XYZ09:45:00 7.5 XYZ09:46:00 7.4 XYZ09:59:00 7.2 XYZ10:00:00 7.3 XYZ10:01:00 7.6 XYZ