Loading

How to get last records of every roll no

Prakash Mondal

My data base table with value using SQL Server 2008 R2

I want to get out put

Please give me a sql query to sorting this.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta6y ago
Accepted answer
Duplicate:
https://www.c-sharpcorner.com/Forums/get-all-records-of-last-row-of-every-roll-no
+1
Matrick Maths6y ago
select a.* from tablenm a where slno = (select max(slno) from tablenm b where a.rollno=b.rollno)
// replace tablenames with your tablename
0