write a query for the fifth highest salary?
Answer Posted / venkates
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What is a database call?
Explain storage manager?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
How to implement database security?
what is rcp,if rcp disabled what happen?
How to do performance tunning a database in DB2 V8.2 UDB in linux
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What is the Lock Based Protocol used for?
What is the difference between database and server?
How many indexes can be created on a table?
What is odm database?
Which three commands cause a transaction to end?
What are database connection details?