Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368401 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 / yash goyal
Select Distinct salary
from employees e
where &no-1=(select count(distinct salary )
from employees
where E.salary < salary);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between explicit and implicit cursors in oracle?
What is data profiling in sql?
Is like operator in sql case sensitive?
What are the two types of periodical indexes?
What is a parameter query?
How do you get column names only for a table (sql server)?
How do you pronounce sql?
Explain isolation levels. : Transact sql
What is multiple columns?
What is dialect in sql?
What is not in sql?
how to get help information from the server? : Sql dba
Why primary key is required?
What is a recursive join sql?
Do we need commit after truncate?
