write a query to find 4th max salary

Answer Posted / anand v

select user_name,sal,rank over(order by sal desc) rank from table
where rank =4

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to drop an existing index in mysql? : Sql dba

714


how to concatenate two character strings? : Sql dba

743


What is benefit of creating memory optimized table?

702


what are all the different normalizations? : Sql dba

685


What are the datatypes available in pl/sql ?

793






What programs use sql?

729


What is the difference between inner join and outer join?

712


What is integrity in sql?

750


Is big data nosql?

692


what is sp_pkeys? : Transact sql

889


What is sharding in sql?

736


What is the difference between subquery and correlated query?

724


What is Materialized View? In What Scenario we Use Materialized View?

8938


What is record variable?

708


What is a subquery in sql?

694