Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to get latest date data set!
- Thread starter choohean
- Start date
Consider the table myTable with 1 column myDateCol..
SELECT *
FROM myTable
WHERE myDateCol = (SELECT DISTINCT TOP 1 myDateCol
FROM myTable
ORDER BY myDateCol DESC)
This query will give you the records which have the latest date in myDateCol.
Hope this helps
SELECT *
FROM myTable
WHERE myDateCol = (SELECT DISTINCT TOP 1 myDateCol
FROM myTable
ORDER BY myDateCol DESC)
This query will give you the records which have the latest date in myDateCol.
Hope this helps
- Status
Similar threads
