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.