Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
How to get the second last record in sql
basit khan
Jan 22 2017 6:22 AM
321
Reply
Hi,
i have below table and the records are
ATN_No, ATN_Number, ATN_Date ,ATN_AstNo
1 A-1 01-01-2016 1
2 A-1 01-01-2016 2
3 A-2 02-01-2016 1
4 A-3 02-01-2016 2
i want below result depend upon ATN_Date and ATN_AstNo.
ATN_No, ATN_Number, ATN_Date ,ATN_AstNo
1 A-1 01-01-2016 1
2 A-1 01-01-2016 2
Thanks
Basit.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
error when start sql server agent
error in start sql server agent