query by recent dates

-Dman100- · #1 (**permalink**) 09-15-04, 12:26

How would I construct a SQL statement that would query the database and return the 5 most recent dates added into the database?

Would I use the TOP SQL keyword to select the 5 most recent entries?

How would I query for the most recent dates?

SELECT TOP 5 *
FROM dbo.tblWeblog
WHERE blogDate = ?

Thanks for any help!
-Dman100-

Pat Phelan · #2 (**permalink**) 09-15-04, 12:30

Close! I'd use:

Code:

SELECT TOP 5 *
   FROM dbo.tblWeblog
   ORDER BY blogDate DESC

-PatP

-Dman100- · #3 (**permalink**) 09-15-04, 14:26

Thanks Pat!
-Dman100-

Internet Services

Web Development

Digital Marketing

Consumer Tech