write a query for the fifth highest salary?
Answer Posted / payal
select salary from emp order by salary desc limit 4,1
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
Explain partial key?
How to do Data integrity testing? Who does this testing (Developer or tester)?
What happens when shared and exclusive locks are applied on data item?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
Differentiate between unique key and foreign key?
Can you tell any two advantages of stored procedures?
What is a database example?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
What is the DIF format and when we will use in teradata
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
can u combine pipeline parallelism and partition parallalism? how and whan?
What is Data Modelling?
How does non-cluster index functions?
What is a driver in database?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?