Answer / naresh raju

select * from emp where rownum<=2
minus
select * from emp where rownum<2

Answer / hema

Both the above answers give no correct result..

The first says bind variable should be declared for :n,
and second gives no rows selected...

Answer / umadevi

SELECT * FROM emp a WHERE 2 = (SELECT COUNT(rowid) FROM
emp b WHERE a.rowid >= b.rowid)

now it will work. instead of :n we have mention row number.

Answer / monika

SELECT * FROM(SELECT a.*,row_number() over(ORDER BY NULL)
rn FROM emp a)
WHERE rn=2

Answer / tulasi ravi kumar

hi this tulasi .....+91-9951123501
in SQL Server 2000 we write as...
declare CurTemp scroll cursor for
select top 2 * from <table_name>
open CurTemp
fetch last from CurTemp
close CurTemp
deallocate CurTemp;

in ORACLE , we can write as..

select * fom <table_name>
where rowid=(select rowid from <table_name>where rownum<=2
minus
select rowid from <table_name>
where rownum<2;

so try it ...

Answer / zeljko

This answer_10 will work only if there is not order by used
on select statement.
I recommend using dense_rank function to get second row out
as in example;

SELECT * FROM (
SELECT id, first_name, salary,
DENSE_RANK() OVER(ORDER BY salary desc) row_order
FROM employee)
WHERE row_order = 2;

Answer / sandhya rani

This is perfect answer...
and do not misguide the ppl by simply writing wrong answer.
until and unless u r perfect..pls do not share your answer


select * from emp where rownum<=2
minus
select * from emp where rownum<2

Answer / vamsi krishna

this query will give the correct answer.
all the answers which are given above are absolutely wrong.
(take it easy who posted them)
select * from (select rownum as r1,empno,ename,sal,deptno
from emp) where r1=2;
(take default emp table for execution)

Answer / bindu

select * from (select rownum r1,e.* from emp e)
where r1=2;

Answer / rajasekar.p

select * from (select a.*,rownum aa from orders a )
where aa=2

Please verify the same you will get the correct answer


Regards
P.Rajasekar

why we use nocopy?

2 Answers   Polaris,

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

How many sql core licenses do I need?

0 Answers  

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

what are the non-standard sql commands supported by 'mysql'? : Sql dba

0 Answers  

What is pl sql collection?

0 Answers  

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

How do you change a value in sql?

0 Answers  

Which join condition can be specified using on clause?

0 Answers  

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers