how to find the second highest salary from emp table?
- 211 Answers
- 320945 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 / raghu munukutla
SQL> select max(sal) from emp where rownum<=(select
count(sal)-1 from emp)
order by sal desc;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a stored procedure in sql with example?
How do you update a sql procedure?
What is database white box testing and black box testing?
Define overloaded procedure?
How many types of index are there?
Can %notfound return null after a fetch?
what is the bond code in materialized view?
Is sql a oracle?
Are left and right joins the same?
What is the difference between subquery and correlated query?
what is a table in a database ? : Sql dba
Write an sql query to select all records from the table?
What is difference between db2 and sql?
What is an inner join sql?
What is the usage of sql functions?
