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

how to findout the 100th maximum salary

Question Posted / g sivanagaraju

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

Please Help Members By Posting Answers For Below Questions

Where is sql database stored?

985

how to create a table index in mysql? : Sql dba

1062

what is the difference between blob and text? : Sql dba

1024

what is a control file ? : Sql dba

1045

What is a natural join?

1075

What is the use of double ampersand (&&) in sql queries? Give an example

1140

What is pl sql and why it is used for?

1113

What are the three pl sql block types?

1010

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

What are system versioned tables?

1032

what are sequences

1753

What is %type in pl sql?

972

What's the difference between inner join and left join?

1002

How do I debug a stored procedure?

1117

Does sql view stored data?

962