write a query for the fifth highest salary?

Answer Posted / p.chella vijaya

select top 5 (salary) from emp order by desc

Is This Answer Correct ?    1 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which database is best to store images?

522


What is the relationship that exists inside in E-R diagram?

627


Is hive a database?

552


Is data lake a database?

559


Differentiate between unique key and foreign key?

579






What is a super key?

618


What is relational database with example?

535


What are the advantages of views in a database?

640


What advantages does DBMS have over traditional file systems?

587


if i want to display the name of students such that to which city they belong must have count greaer than two

1769


What are the various ways to execute a query in teradata?

2187


Is database a hardware or software?

536


What is difference between server and database?

563


How is image stored in database?

573


Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

584