How can get alternate highest salary or any record in a table in SQL Server ?

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 ?

Last updated:8/6/2018 2:24:41 AM

2 Answers

Anonymous User
Anonymous User

USE DENSE_RANK FUNCTION for this operation. 

MSSQL DENSE_RANK FUNCTION SYNTAX

DENSE_RANK ( ) OVER ( [ <partition_by_clause> ] <order_by_clause> )

Answer