how to findout the 100th maximum salary

Answer Posted / g sivanagaraju

SELECT sal
FROM emp e
WHERE &100=(SELECT COUNT(DISTINCT(SAL))
FROM emp
WHERE e.sal<=sal);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to return an array from java to pl/sql?

790


What company owns postgresql?

772


How do I enable sql encryption?

715


explain commit and rollback in mysql : sql dba

732


what is 'mysqlshow'? : Sql dba

756






what are the types of join and explain each? : Sql dba

770


What is a data manipulation language?

749


How does a trigger work?

721


what is meant by nl2br()? : Sql dba

766


What is varchar used for?

752


what is a trigger in mysql? : Sql dba

786


Mention what does the hierarchical profiler does?

736


Does normalization improve performance?

769


what is error ora-03113: end-of-file on communication channel?

823


Is left join faster than join?

762