Find out the 3rd highest salary?
Answer Posted / sachin saini
select min(salary) from table_name where salary in(select
top 3 salary from table_name order by salary desc )
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why we use cross join?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What are the benefits of pl sql?
what happens if null values are involved in expressions? : Sql dba
How many aggregate functions are available there in sql?
What are procedures used for?
How do I order columns in sql?
what is auto increment? : Sql dba
Explain the structure of pl/sql in brief.
Can we group by two columns in sql?
What is meant by <> in sql?
What are the types of join and explain each?
How do you concatenate in sql?
Why is sharding used?
Why is normalization important?