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
Comparable and Comparator Interface in Java Generics In Java Utility class in java
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 Selenium 4 features
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)