perhaps you are looking for something like
select entry,timestamp from table A where A.timestamp=(select max(B.timestamp) from table
B where a.entry=b.entry);
also this oage may be helpful:
http://www.artfulsoftware.com/infotree/queries.php
re,
wh
Am 30.11.2012 02:39, schrieb hsv@stripped:
>>>>> 2012/11/29 11:46 +0530, Trimurthy >>>>
> i have a table which contains the columns
> date,sname,age,item,quantity,units.my question is i want to retrieve all
> the values from the table where date=maxdate group by sname how can i get
> those values.
> <<<<<<<<
> A question, I suspect, found in all SQL courses....
>
>

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.