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.
Amit GuptaPosted May 17, 2020, 5:31 AM
Amit GuptaPosted May 23, 2020, 11:02 AM
Prakash MondalPosted May 23, 2020, 6:04 AM
Prakash MondalPosted May 17, 2020, 5:10 AM
Salman BegPosted May 16, 2020, 10:02 PM