Oracle SQL, PL/SQL Quiz online Test

Thanks for taking the exam, Anju

Hi, I went through the site giving by you..:http://www.oraclepassport.com
In Oracle General Interview Questions Part1, there is question no. 13 'Query to find the nNth Highest salary', the answer is wrong..it should be
select min(sal) from (select distinct sal from emp order by sal desc) where rownum <= n;(the = sign should also be there as this will return the correct answer)

With or without '=' it will provide the correct answer since you are looking out for the MIN(Sal)

I tried it without'=' sign but I am not getting the right ans..belwo is a example:

I have a table called emp, which have records as below:
select * from emp;

EMPNO ENAME SAL
------ -------------------- ----------
1 Dipti 5000
2 Abhi 10000
3 Swati 7000
4 ABC 2000

If I want second highest sal(which should be 7000) the query
select min(sal) from (select distinct sal from emp order by sal desc) where rownum < 2; is ruturing

MIN(SAL)
---------
10000

but if I am using below query, it is returing right ANS
select min(sal) from (select distinct sal from emp order by sal desc) where rownum < =2;

MIN(SAL)
----------
7000

Hope u understande what I am trying to say...

Well that depends on your logical thinking. If you want 2nd highest salary you should put <3.

Thanks for your feedback. We came across the error earlier itself. But in Wiziq we are unable to edit the Tests once created!!! We request all test takers to take the correct answer as "NO" for question number 3.

The correct answer will be 'yes, but not always'.