Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361084 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
Can a key be both primary and foreign?
Who developed sql?
How do I truncate a word?
What is cross join example?
Explain the difference between rename and alias?
what are the different index configurations a table can have? : Sql dba
What are synonyms in sql?
How does sql profiler work?
What is dml and ddl?
What is sql scripting?
Why stored procedure is better than query?
what are the security recommendations while using mysql? : Sql dba
Is vs as in pl sql?
what is online transaction processing (oltp)? : Sql dba
What is the meaning of disabling a trigger?
