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.

Duplicate: https://www.c-sharpcorner.com/Forums/get-all-records-of-last-row-of-every-roll-no

select a.* from tablenm a where slno = (select max(slno) from tablenm b where a.rollno=b.rollno) // replace tablenames with your tablename

Answers

How to get last records of every roll no

Prakash Mondal

866

1 SQL

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.

Forum Statistics

Upcoming Events

View all