sql query
Posted by:
war head
Date: January 15, 2009 08:55PM
Hi, i got one problem. Here is the problem.
-----------------------------
name | date | time | status
----------------------------
one | 1/1/2008 | 1.12 | A
two | 1/1/2008 | 1.13 | A
one | 1/1/2008 | 2.20 | B
two | 1/1/2008 | 3.00 | B
one | 1/1/2008 | 14.20 | A
one | 1/1/2008 | 17.20 | A
My goal now is,how to do a query to get name with the lastest status. The result should be, if i want the name with "A" status, the answer will be " one | 1/1/2008 | 17.20 | A ".
I hope someone out there can help me. Thanks in advance.
Subject
Written By
Posted
sql query
January 15, 2009 08:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.