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 join in sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What are the types of variable use in pl sql?
how many groups of data types? : Sql dba
How to convert comma separated string to array in pl/sql?
how to rename an existing column in a table? : Sql dba
How do I count records in sql?
What is join view in sql?
What does pragma mean?
how to concatenate two character strings? : Sql dba
What is the difference between function, procedure and package in pl/sql?
How do you determine the current isolation level? : Transact sql
How do I edit a stored procedure?
How does a self join work?
Why do we use joins in sql?