Write a query to find second highest salary of an employee.
Answer Posted / om patel
select (distinct(a.sal) from emp e where rownum=&N(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is bitemporal narrowing?
What is trigger point?
Does sql between include endpoints?
What are the different type of joins in sql?
What is Materialized View? In What Scenario we Use Materialized View?
What is join view in sql?
What is blind sql injection?
Is oracle and sql same?
what are the types of join and explain each? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
what is “go” in t-sql? : Transact sql
What are the limitations of sql express?
Why triggers are used?
Why is a primary key important?