how to get second highest salary in SQL(as/4000
- 29 Answers
- 28266 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / c srirammulu
select * from emp a where &n=(select count(distinct (sal))
from emp f where a.sal<f.sal)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Is it possible to pass parameters to triggers?
What is primary key secondary key alternate key candidate key?
Why indexing is needed?
What is the trigger in sql?
What is a table in a database?
Explain unique key in sql.
Which is faster joins or subqueries?
What are the ways on commenting in a pl/sql code?
How subquery works in sql?
what is a composite primary key ? : Sql dba
What is self-join and what is the requirement of self-join?
What is the purpose of a secondary key?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is %rowtype in pl sql?
What is an inconsistent dependency?
