MainMenu

Home Java Overview
Download & Install Sample program to find greater no. Boolean Operatot & Array
Java Object Class & Method with example Singleton Class & Method in java with example Method Overloading in Java with Example
Inheritance in java with example Method overriding in java with example Polymorphism in Java With example
Constructor, Super & this keyword in java Encapsulation in Java with example Abstraction in Java with example
Interface in Java with example String in Java with example toString() method in Java with example
Package in java with example Exception Handling in java with example Static keyword in Java with Example
Upcasting and Downcasting in Java Swap two variable in java Scanner class in java
Java 8 Stream Filter with Example reverse the string in java without using functions Sort the array without using Java functions
Difference between Final, Finally and Finalize in Java for each loop in java with example Hashmap in Java
How to find duplicate element in array Difference Between Collection & Collections Can we override static/private method
Data Structure in Java Dictionary & serialization in java How to Read & write Excel in Java
Collection Interface In Java MultiThreading in Java JDBC in JAVA
Reflection in Java Constructor chaining in java Wrapper Class in java
Loose Coupling and Tight coupling in java with example POJO Class in Java with Example How to Validate String is number in java
Get State Name by City name Get State Name by City Name in India
History of Selenium, Architecture Practice Page download Install Selenium & TestNG
Accessing WebElements In Selenium Access basic Web elements create xPath & Css path Manually
Pageobject Model in Selenium Automate Firefox, chrome & IE DATA Driven Framework
verify links on Webpage keyword Driven Framework Hybrid Driven Framework
Different Wait in Selenium Take screen shot in selenium HeadLess Browser testing in Selenium
Create WebDriver Instance for multiple class scroll browser in Selenium Send Reports Automatically to Email using Maven
Handle Frames in Selenium Handle Tabs in selenium Perform Right Click Action
How to upload file in selenium How to get number of rows in html able Listeners In TestNG
Read the tool tip text in selenium How to press multiple keys in selenium JavascriptExecutor usage in Selenium
Selenium Integration with AutoIT
Introduction of Appium Download and configure Automation mobile web Application Find App Package & App Activity Appium Automate Whatsapp Appium Example Calling Numer How to scroll in appium Data Driven Framework in Appium
Maven Tutorials
API Testing Overview HTTP Request and HTTP Response Overview of WebServices Rest Assured methods API Testing Interview Questions RestAssured Interview Questions Contract Testing
Configure Cucumber Junit Maven Configure Cucumber TestNG Maven Latest Testing Jobs Previous Testing Jobs Previous Testing Jobs
Contact Us
☰

Sunday 15 January 2017

SQL Query to find second highest salary

Query to get second highest salary from table.


Consider the below Table : Salary
Emp_idEmp_Salary
0125000
0230000
0335000

Query 1 :Using a function Select MAX(Emp_salary) from Salary Where Emp_salary < (Select MAX(Emp_salary) from Salary)
Result :

Emp_Salary
30000


Query 2 :Using Limit Select Emp_salary from Salary order by Emp_salary desc Limit 1,1 Result :

Emp_Salary
30000


Note : Limit a,b means left a rows from top and show b number of rows.

Query to get 3rd highest salary from Employee table.

Consider the below Table : Salary:
Emp_idEmp_Salary
0125000
0230000
0335000

Query 1 :Using a function Select MAX(Emp_salary) from Salary Where Emp_salary < (Select MAX(Emp_salary) from Salary Where Emp_salary < (Select MAX(Emp_salary) from Salary) ) Result :

Emp_Salary
25000


Query 2 :Using Limit Select Emp_salary from Salary order by Emp_salary desc Limit 2,1 Result :

Emp_Salary
25000


Tag : Query to get second highest salary without function,Query to get 3rd highest salary from employee table

By at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)