Скачать или смотреть SQL Tutorial Part 8 | How to find 2nd Highest Salary | Find Nth Salary | 4 ways to get it

#AutomationTestingInsider #SeconHighestSalary #NthHighestSalary
In this video, we will discuss about how to get second highest salary, Nth highest salary in employee table:
Please find the below queries here (Note: Since angled bracket not allowed in description box, I have written it like less than)
Using sub-query (With less than Operator):
Select max(Salary) As Salary from EmployeeDetail where
Salary less than (Select max(Salary) from EmployeeDetail)
Using sub-query (With Not In Operator):
Select max(Salary) As Salary from EmployeeDetail where
Salary NOT IN (Select max(Salary) from EmployeeDetail)
Using correlated sub-query:
Select distinct Salary from EmployeeDetail A
Where 2=(Select count(distinct salary) from EmployeeDetail B where
A.Salary less than or equal b.Salary)
Using TOP Clause keyword
Select top 1 Salary From
(Select distinct top 2 Salary from
EmployeeDetail Order by Salary Desc)
As Temp Order by Salary

second highest salary in SQL
third highest salary in SQL
nth highest salary
how to find 2nd highest salary
how to get 3rd highest salary

Selenium Framework Development(from scratch) Videos:
   • Selenium Framework Development Part6|Log4j...  

SUBSCRIBE:    / @automationtestinginsider  

About this channel:
This channel is dedicated to Software Testing, Automation Testing, Devops, Agile and TestNG, Maven, Jenkins, Git, Github, RPA, Agile, Devops, Database, Domain and many more.

Selenium WebDriver Step By Step:
   • Selenium WebDriver | Selenium WebDriver an...  

Java Step By Step:
   • Java for Selenium | Part1 | First Java Pro...  

TestNG Tutorials:
   • Selenium WebDriver | Part38 | Introduction...  

ScreenShots,Logs,Reports,Properties File
   • Selenium WebDriver | Part52 | How to Captu...  

Maven Tutorials:
   • Selenium WebDriver | Part48 | Maven Introd...  

Page Object Model:
   • Selenium WebDriver | Part62 | Page Object ...  

Excel and DataDriven Framework
   • Selenium WebDriver | Part65 | Read Excel f...  

Git and GitHub:
   • Selenium WebDriver | Part70 | Selenium Int...  

Jenkins Videos:
   • Selenium WebDriver | Part73 | Selenium Int...  

Selenium Framework Development Videos:
   • Selenium Framework Development Part6|Log4j...  

Core Java Interview Questions and Answers
   • Important Java Questions | Java interview ...  

Selenium WebDriver Interview Questions and Answers
   • Interview Questions on Selenium | Selenium...  

Please Subscribe this channel and press bell icon to get some interesting topics on Java and Selenium and other tools.
   / @automationtestinginsider  

Please check out my blog here:
https://www.automationtestinginsider.com

Follow Facebook Page
  / hverma22  

Follow me on instagram
  / hitendrahita