TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Prakash Mondal
NA
288
208.7k
How to get last records of every roll no
May 17 2020 5:33 AM
My data base table with value using SQL Server 2008 R2
ROLL NO
SLNO
TRXN DATE
CLOSING AMOUNT
16CS1001
1
700
16CS1008
2
1000
16MA1006
1
1300
16CS1001
2
800
16CH1201
1
1000
16CS1008
1
1600
16MA1006
2
1200
16CH1201
2
500
16CS1008
3
900
16MA1006
3
700
16CS1008
4
500
I want to get out put
ROLL NO
SLNO
TRXN DATE
CLOSING AMOUNT
16CS1001
2
800
16CS1008
4
500
16MA1006
3
700
16CH1201
2
500
Please give me a sql query to sorting this.
Reply
Answers (
2
)
Clear all data from all tables and reset id ms sql server
Trigger on insert