Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
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

forum

home / developersection / forums / how can get alternate highest salary or any record in a table in sql server ?
Ask Question

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

Anonymous User 1378 02 Aug 2018

Get alternate records in a table like as 

NameRollNoMarks
A140
B250
C355
D448
E666


how can get 2nd, 4th, and 6th position of marks ?

mssql server sql serverdatabase table
Updated 06 Aug 2018
Anonymous User
Anonymous User

A_Philosopher

I am a content writter !

Message

2 Answers

Koi Ken
Koi Ken 06 Aug 2018
Report Abuse
Post is removed by the Admin.
Anonymous User
Anonymous User 03 Aug 2018
Report Abuse

USE DENSE_RANK FUNCTION for this operation. 

MSSQL DENSE_RANK FUNCTION SYNTAX

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