write a query for the fifth highest salary?
Answer Posted / bhramar
select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal desc) a order by Sal
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of normalization? What is the use of it?
Explain database partitioning. What is its importance?
What are database connection details?
Should I store images in database?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
sparse lookup and where its options we find in OCI and db2?
What is difference between clustered, non-clustered and unique index?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
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
How to shrink a database?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
Explain entity ?
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?
Is database a hardware or software?
What is the function of cluster index?