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

Does oracle use sql?

939

How do you add a column to a table?

1066

is mysql query is case sensitive? : Sql dba

1112

What is database migration?

974

What is compute?

1099

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1131

What is scalar data type in pl sql?

1077

What is the difference between inner join and natural join?

1015

Which is better stored procedure or query?

964

How do you sort in sql?

1034

What is the advantage of nosql?

1066

Are views faster than queries?

1002

What is a trigger in sql?

1211

What is cursor explain with example?

993

Can we rollback truncate?

1008