Home
Download
_Source Code (Payhip)
_Payhip
Category
_C#
_ASP.NET MVC
_ASP.NET Core 2.2
_ASP.NET Core 3.0
Blazor
_Blazor All Topics
_Radzen Blazor
_Syncfusion Blazor
_Blazored
JQuery
_Kendo UI
_Kendo UI ComboBox
_Kendo UI Grid
_Kendo UI Window
_Kendo UI DatePicker
_AmCharts
SQL
Reporting
_RDLC Report
_Crystal Report
_All Reports
Courses
_Download Courses
Blog
Result
Contact
About Me
Home
SQL Server
How to get 3rd, 5th or 6th i.e. N'th highest Salary?
How to get 3rd, 5th or 6th i.e. N'th highest Salary?
AshProgHelp
Thursday, September 20, 2018
SELECT * FROM EMPLOYEE E
WHERE 2 = (SELECT COUNT(DISTINCT E1.SALARY)
FROM EMPLOYEE E1
WHERE E1.SALARY>E.SALARY)
Here, 2= 3-1 i.e. N-1 ; can be applied for any number.
Post a Comment
0 Comments
About Me
H
i, I'm
Ashraful
Professional .NET Developer
Pages
Blog
Courses
Source Code Download
Online Courses Download
Like this Blog?
Buy me a coffee
Categories
Blazor
62
ASP.NET Core 3.1
20
Kendo UI
20
Asp.Net Core
19
SQL Server
17
Xamarin Forms
12
.NET 5
10
.Net Core API
10
.NET MAUI
9
C#
8
Radzen.Blazor
8
RDLC
7
Reporting Tools
7
AmCharts
6
JQuery
6
Web API
6
Syncfusion Blazor
4
ASP.Net MVC
2
Crystal Report
2
TFS
1
Visual SVN
1
Windows Form Application
1
Subscribe Now
Find us on Facebook
Join this Group
Popular Posts
InputRadio & InputRadioGroup Components in Blazor | .NET 5
Wednesday, November 04, 2020
.NET MAUI CRUD Using .NET 6 Web API || MAUI Web API CRUD | EP:11
Friday, September 23, 2022
How to print directly without showing report viewer in rdlc report ?
Tuesday, January 10, 2017
Followers
Featured Post
ASP.NET Core 3.0
JWT Authentication in ASP.NET Core Web API
Wednesday, April 15, 2020
Blog Archive
2022
10
2021
39
2020
84
2019
49
2018
27
2017
2
2016
5
Live Traffic Feed
A visitor from
Moscow
viewed '
InputRadio & InputRadioGroup Components in Blazor
'
4 hrs 27 mins ago
A visitor from
Perm
viewed '
How to Create an ASP.NET Core Web Application with
'
4 hrs 28 mins ago
A visitor from
Manama
viewed '
AshProgHelp
'
8 hrs 31 mins ago
A visitor from
Glen carbon
viewed '
Load Menu & Sub Menu From Database in Blazor
'
9 hrs 45 mins ago
A visitor from
Calgary
viewed '
AshProgHelp
'
11 hrs 23 mins ago
A visitor from
Riyadh
viewed '
AshProgHelp
'
13 hrs 57 mins ago
A visitor from
Hanoi
viewed '
AshProgHelp
'
14 hrs 45 mins ago
A visitor from
Perm
viewed '
5
'
17 hrs 35 mins ago
A visitor from
Moscow
viewed '
How to use Sub Menu in Blazor
'
17 hrs 36 mins ago
A visitor from
Lake worth
viewed '
AshProgHelp
'
1 day 13 hrs ago
Real-time
|
Get Script
|
More Info
Website Counter
Total Pageviews
2
8
3
8
9
5
0 Comments