write a query for the fifth highest salary?
Answer Posted / shahid
select *from(select sal,rank() over(order by sal desc)as sal_rank from emp) where sal_rank=5;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
What are the advantages of normalizing a database.
How to shrink a database?
What is the role of driver manager?
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.
If the master device is full, how do I make the master database bigger?
What are indexes in oracle?
how can we view column head in first page but not in remaining pages?
What are the advantages of views in a database?
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
Explain database partitioning. What is its importance?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Display the employees whose salary is less than average salary.
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
Explain the various types of normalization.