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
How do you update a value in sql?
Does a user_objects view have an entry for a trigger?
What is number function in sql?
What are sql queries used for?
What mean sql?
Define select, insert, create, delete, update, drop keywords
how to create a new table in mysql? : Sql dba
Which query operators in sql is used for pattern matching?
What is a heap in sql?
what is heap table? : Sql dba
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What are the most important characteristics of pl/sql?
Can we call dml statement in function?
Can sql function call stored procedure?
what is the difference between group by and order by in sql? : Sql dba