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.
| Author |
Topic |
|
vishu.m
Starting Member
2 Posts |
 Posted - 2008-12-18 : 05:15:40
|
| What is the query used to get most recently inserted or updated record in a table |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-12-18 : 05:20:30
|
| can u post ur table structure r do u have any date column in ur table the u can get the records by date column |
 |
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2008-12-18 : 05:22:00
|
| If you have date column try thisSELECT * FROM yourtable ORDER BY CreatedOn DESC SELECT * FROM yourtable ORDER BY LastModifiedOn DESCJai Krishna |
|
|
|
|
|
|
Recent records..