Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Anonymous User 1400 02 Aug 2018

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 ?

Anonymous User

A_Philosopher

I am a content writter !

2 Answers

Koi Ken 06 Aug 2018

Post is removed by the Admin.

Anonymous User 03 Aug 2018

USE DENSE_RANK FUNCTION for this operation.

MSSQL DENSE_RANK FUNCTION SYNTAX

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

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.