write a query for the fifth highest salary?

Answer Posted / suparna

select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)

Is This Answer Correct ?    8 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the database url?

558


How is image stored in database?

586


What is the use of graph database?

553


What is global database name?

553


Can you create a database in word?

532






What is a database string?

530


How to do Data size testing? Who does this testing (Developer or tester)?

2129


What is difference between server and database?

574


how node connect with cpu?

1673


What are different types of resources?

535


What is the purpose of firebase?

550


HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2152


What is a Database?

598


What are different types of joins used in?

637


Why do we need distributed database?

550