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.