Working with Dates - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Working with Dates

Author

Topic

hasanali00
Posting Yak Master

207 Posts

Posted - 2006-03-13 : 11:47:16

Hi, I wonder if you could help me with this date query;

I have:


Products:
ProductID  int
DateModified datetime

I want to return top 10 rows that have been newly modified. How can I write such query?

I hope u understand what I mean.

regards

nosepicker
Constraint Violating Yak Guru

366 Posts

Posted - 2006-03-13 : 11:48:50

SELECT TOP 10 * FROM YourTable
ORDER BY DateModified DESC

hasanali00
Posting Yak Master

207 Posts

Posted - 2006-03-14 : 05:42:41

Damn...this was sooooo simple.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources