how to find the second highest salary from emp table?
- 211 Answers
- 322005 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 / sankar sasmal
select distinct sal from emp e where 2=(select count(distinct sal)from emp s where e.sal<=s.sal)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which operator is used in query for pattern matching?
What is break?
How do I truncate a word?
Can you selectively load only those records that you need? : aql loader
How does an execution block start and end in pl sql?
Can there be more than one function with a similar name in a pl/sql block?
What are the benefits of pl sql?
How does stored procedure reduce network traffic?
How to display the current date in sql?
What are expressions?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is the use of index in hive?
how can we submit a form without a submit button? : Sql dba
What is the difference between inner join and left join?
What is bind reference and how can it be created?
