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.2k
get all records of last row of every roll no
May 16 2020 8:18 PM
My data base table with value using SQL Server 2008 R2
ROLL NO
SLNO
TXN 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
TXN 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 (
5
)
Setup custom time zone for azure elastic pool database
Get working days,hours,minutes between two dates in sql serv