How is the SQL query for retrieving the recordset with the latest date (in the field myDate)?
The following 2 SQL queries don't work like I want them to work:
SELECT * FROM myTable WHERE myDate >= ALL (SELECT myDate FROM myTable);
SELECT * FROM myTable WHERE myDate = (SELECT MAX(myDate) FROM myTable);
Assuming there are the following dates in the table:
both queries return 31.12.2005 but they should return 06.04.2006