Interested to Buy Any Domain ? << Click Here >> for more details...
Find out the 3rd highest salary?
- 51 Answers
- 73546 Views
- BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar
SELECT DISTINCT SAL FROM EMP WHERE SAL = (SELECT DISTINCT
SAL FROM EMP X WHERE &N= (SELECT COUNT(DISTINCT SAL) FROM
EMP Y WHERE Y.SAL>X.SAL))
/
AFTER RUNNING THE QUERY PUT THE VALUE OF N
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can we find duplicate records in a table?
What is 19 null in sql?
What problem one might face while writing log information to a data-base table in pl/sql?
Which query operators in sql is used for pattern matching?
What is join view in sql?
What is trigger in sql and its types?
How do I save the results of sql query in a file?
In what condition is it good to disable a trigger?
What are the various restrictions imposed on view in terms of dml?
Can I call a procedure inside a function?
How does sql developer connect to oracle database?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Why do we need unique key in a table?
What is sql query optimization?
What are local and global Indexes and where they are useful.
