OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SQL question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL question [message #1366]

Wed, 24 April 2002 07:46

Steve
Messages: 190
Registered: September 1999

Senior Member

This query sorts the SITE_REVIE field, a date field,
in descending order. How would I change this query to extract only the most recent i.e. the last date for
each ID.

I'm performing this query in Microsoft Access 2000.

Thank you.

Steve Segore

SELECT [[MARO Site Visit Status Query 1]].Id, [[MARO Site Visit Status Query 1]].SITE_REVIE, [[MARO Site Visit Status Query 1]].FACILITY, [[MARO Site Visit Status Query 1]].REGION, [[MARO Site Visit Status Query 1]].REPT_RECD, [[MARO Site Visit Status Query 1]].FOLLOW
FROM [[MARO Site Visit Status Query 1]]
ORDER BY [[MARO Site Visit Status Query 1]].Id, [[MARO Site Visit Status Query 1]].SITE_REVIE DESC;

Report message to a moderator

Re: SQL question [message #1370 is a reply to message #1366]

Wed, 24 April 2002 07:58

motiram
Messages: 21
Registered: January 2001

Junior Member

SELECT
[[MARO Site Visit Status Query 1]].Id, [[MARO Site Visit Status Query 1]].SITE_REVIE, [[MARO Site Visit Status Query 1]].FACILITY, [[MARO Site Visit Status Query 1]].REGION, [[MARO Site Visit Status Query 1]].REPT_RECD, [[MARO Site Visit Status Query 1]].FOLLOW
from
(
select *
FROM [[MARO Site Visit Status Query 1]]
ORDER BY [[MARO Site Visit Status Query 1]].Id, [[MARO Site Visit Status Query 1]].SITE_REVIE DESC;
)
where rownum < 1

Cheers.

Report message to a moderator

Previous Topic:	How to get even rows!.
Next Topic:	sql script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 03 22:42:51 CST 2025