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

write a query to find 4th max salary

Question Posted / anand v

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

Please Help Members By Posting Answers For Below Questions

What does := mean in pl sql?

989

is mysql query is case sensitive? : Sql dba

1029

Can primary key be changed?

861

What is a sql*loader control file?

1156

Which one is faster ienumerable or iqueryable?

864

What is a subquery in sql?

974

What is set serveroutput on?

1086

What is spool?

990

Do ddl statements need commit?

920

Difference between truncate, delete and drop commands?

1022

Is hadoop a nosql?

946

What is the current version of postgresql?

1003

Do we need to rebuild index after truncate?

972

Explain select statements in sql?

998

What are some predefined exceptions in pl/sql?

1055