write a query to find 4th max salary

Answer Posted / nishi.swain@gmail.com

select distinct sal from table_name t1 where 4=(select count(distinct sal) from table_name t2 where
t1.sal<=t2.sal);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the reports view in oracle sql developer?

535


What is the syntax to add a record to a table?

569


What is the difference between microsoft access and sql server?

523


How do you delete duplicates in sql query using rowid?

531


How can get second highest salary in sql?

497






What is sql integrity?

575


What is data profiling in sql?

509


what is a field in a database ? : Sql dba

533


Why is sharding used?

544


Which is faster subquery or join?

649


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

605


Which one is faster ienumerable or iqueryable?

479


what is column? : Sql dba

562


Is sql scripting language?

519


how to concatenate two character strings? : Sql dba

542