write a query for the fifth highest salary?
Answer Posted / bezalel
select salamt from
(
select rownum n,salamt from
(
select distinct salamt from emp order by salamt desc
)
)
where n=5
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the most common databases?
What is the use of default key?
When should you not use firebase?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
Why merge statement is used inside the 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 ?
Explain entity type?
Explain inner and outer joins with examples.
What is a database example?
Why do we need distributed database?
How do you pass parameter in stored procedure?
How do I manually create a database?
sparse lookup and where its options we find in OCI and db2?
Explain transaction manager?