write a query for the fifth highest salary?
Answer Posted / prasanna
select max(sal) from emp where sal not in (select Top 4 sal
from emp order by sal desc)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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
What are different types of clusters present?
what is tkprof tool and how it is used???
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What is the candidate key used for?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
What are the advantages of normalizing a database.
Explain phantom deadlock?
Differentiate between delete and truncate table?
aht is the difference b/w network & hierarchial & relational dbms????
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What are the advantages of views in a database?
what is the full procedure for using store procedure in informatica7.1?
What advantages does DBMS have over traditional file systems?