how to find the second highest salary from emp table?
Answer Posted / raghavendraprasad
select salary from emp e where &n-1=(select count(*) from
emp where salary>e.salary);
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
Is sql microsoft?
How many disk partitions should I have?
Explain the the delete statements in sql?
how to create a new view in mysql? : Sql dba
How to run sql*plus commands in sql developer?
Describe sql comments?
What does := mean in pl sql?
What does the hierarchical profiler does?
Do we need commit after truncate?
What is sql and how does it work?
What are joins in sql?
What are pl sql procedures?
what are the nonstandard string types? : Sql dba
Can procedure in package be overloaded?
what is the difference between char_length and length? : Sql dba