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
What are the advantages of using database?
What is a Transformation?
What is difference between server and database?
Explain transaction manager?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
WHAT KIND OF TOOL BO IS?
give a simple example of physical and logical data independence
Explain alternate key?
What is the use of default key?
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.
Explain the various types of normalization.
what is data access layer?
How do you pass parameter in stored procedure?
How to produce such kind of file?
What is the purpose of firebase?