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
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
What does specialization in DBMS mean?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Difference between sql and mysql?
how do you do sql tuning?
What is difference between data and database?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
What is odm database?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
Should I store images in database?
What is the difference between data source and database?
Why do we need distributed database?
What are different types of data models available? Explain with example?
how node connect with cpu?