Get alternate records in a table like as
| Name | RollNo | Marks |
| A | 1 | 40 |
| B | 2 | 50 |
| C | 3 | 55 |
| D | 4 | 48 |
| E | 6 | 66 |
how can get 2nd, 4th, and 6th position of marks ?
How can get alternate highest salary or any record in a table in SQL Server ?
Ask by Anonymous User
Updated 06 Aug 2018
USE DENSE_RANK FUNCTION for this operation.
MSSQL DENSE_RANK FUNCTION SYNTAX