Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 372957 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 / ankit khanijau
Select salary from emp
where MAX(Select salary from emp where salary != MAX(salary))
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How subquery works in sql?
Do we need to create index on primary key?
What is pl sql block structure?
What is the difference between drop and truncate commands?
What is a composite primary key?
how to get a list of all tables in a database? : Sql dba
Why is stored procedure faster than query?
What is a behavioral trigger?
What is pl sql in dbms?
What are tables in sql?
What is the use of prepared statement?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What are different clauses used in sql?
What are the query optimization techniques?
Explain alias in sql?
