Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373092 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / amit singh
forget the book
Empsal table data
700
500
100
900
400
200
600
750
query to find second highest salary from table Empsal
mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<(select max(salary) from Empsal));
Output=750
query to find third highest salary from table Empsal
mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
>(select max(e1.salary) from Empsal e1
>where e1.salary IN(
>select e2.salary from Empsal e2 where
>e2.salary<(select max(salary) from Empsal))));
Output=700
RUN THE QUERY THEN ARG
amitsing2008@gmail.com(amit is back on this site)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is pl/sql table? Why is it used?
Which join condition can be specified using on clause?
Is stored procedure faster than query?
What is the difference between having and a where in sql?
How do I view a table in sql?
What is the difference between null value, zero, and blank space?
What does the sign mean in sql?
What is meant by cursor in sql?
What is rename in sql?
what are local and global variables and their differences? : Sql dba
What are different joins used in sql?
Explain what is an index?
What is the difference between having clause and where clause?
What is difference between sql and mysql?
What is int identity in sql?
