Home » SQL & PL/SQL » SQL & PL/SQL » SQL question
SQL question [message #1366] Wed, 24 April 2002 07:46 Go to next message
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 Go to previous message
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.
Previous Topic: How to get even rows!.
Next Topic: sql script
Goto Forum:
  


Current Time: Fri Mar 29 07:23:18 CDT 2024