Retrieving last rows from each DISTINCT set

[daniyalnawaz]

Hi!

Suppose there is a table MarketData and has following data

id--symbol--------date--------------time------price
1-----A--------2007-09-28------09:30:00------37.03
2-----A--------2007-09-28------10:30:00------38.75
3---MSFT----2007-09-28------09:30:00-----44.54
4 --MSFT----2007-09-28------10:00:00-----45.63
5---ABK------2007-09-28-------09:30:00-----63.08
6---ABK------2007-09-28------11:00:00-----53.80


Now what I want to do is that i want to retrieve the last rows of every distinct symbols (order by time desc).


id----symbol------date--------------time------price
2-----A--------2007-09-28------10:30:00-----38.75
4 --MSFT----2007-09-28------10:00:00----45.63
6---ABK------2007-09-28------11:00:00-----53.80

Thank you!!

[mwasif]

This will work for you

SELECT * FROM (
          SELECT * FROM marketData ORDER BY date DESC, time DESC
) tmp
GROUP BY symbol
ORDER BY symbol

[daniyalnawaz]

hey thank you!
that really works....

again thanks...

[mwasif]

You are welcome:-)..