write a query for the fifth highest salary?
Answer Posted / p.chella vijaya
select top 5 (salary) from emp order by salary desc
| Is This Answer Correct ? | 1 Yes | 14 No |
Post New Answer View All Answers
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
how do you do sql tuning?
Explain artificial key?
Explain various types of locks in a transaction? Which is better and why?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
What happens when shared and exclusive locks are applied on data item?
what is transaction state, buffer management, shadow paging
Explain storage manager?
What will happen non-clustered index will be created on clustered index?
What are the types of indexes that are present inside a database?
How much does it cost to build a database?
Write a query to retrieve for many to many relationships?
what is rcp,if rcp disabled what happen?