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;
|
|
|
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.
|
|
|