SELECT MAX 1

[Extension]

Hi,

I'm trying to query a table in order to get the latest record with MAX(DATE)
I have 2 conditions before selecting the lastest record. I cannot use the SELECT MAX statement in my initial SELECT statement because I need to check the records against the 2 conditions before.

SELECT *
FROM PROFILES
WHERE ACTIVE = 1
AND PROFILE_TYPE = 'TEST'
ORDER BY DATE

 

[PHV]

SELECT A.*
FROM PROFILES AS A
WHERE A.ACTIVE = 1 AND A.PROFILE_TYPE = 'TEST'
AND A.DATE = (SELECT Max(B.DATE) FROM PROFILES AS B WHERE B.ACTIVE = 1 AND B.PROFILE_TYPE = 'TEST')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Extension]

Great. Thanks