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 is the primary use of normalization?

516

What is the use of partition by in sql?

508

What is mdb stand for?

547

what are the properties and different types of sub-queries? : Sql dba

496

what are the advantages and disadvantages of cascading style sheets? : Sql dba

543

what is 'mysqladmin' in mysql? : Sql dba

524

Is sql free?

493

what is single byte over head in oracle..?

1860

What is the limitation on the block size of pl/sql?

522

Does a join table need a primary key?

522

Why query optimization is needed?

507

can sql servers linked to other servers like oracle? : Sql dba

539

What is trigger types of trigger?

545

What is sql not null constraint?

591

Are stored procedures faster than queries?

515