Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373024 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 / kiran
select max(sal) from emp where sal in(select sal from emp
where sal<>(select max(sal) from emp))
/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is not null in sql?
How bulk collect improves performance?
What does pragma mean?
What are types of joins?
Can a commit statement be executed as part of a trigger?
What is posting?
The select into statement is most often used to create backup copies of tables or for archiving records?
what are the different index configurations a table can have? : Sql dba
What is sql*loader and what is it used for?
What is the sql query to display the current date?
Why do we use %rowtype & %type in plsql?
What are the operators used in select statements?
How to return an array from java to pl/sql?
What are the operators in sql?
Is sqlite thread safe?
