Sai

• Sep 9th, 2006

 

You can use ROWID

dev

• Sep 13th, 2006

 

Hi,

Try this one.

select * from employee where rownum<=3
minus
select * from employee where rownum<=1

with this u can retrieve 2nd and 3rd rows only.

anil

• Oct 11th, 2006

 

Dev,

According to you specified querry.. i am not able to fetch 2 & 3 rows from table.(i am using winsql).

select * from employee where rownum<=3
minus
select * from employee where rownum<=1

showing error: 

Error: SQL0104N An unexpected token "minus" was found following "AILS where rownum<=3"

dev

• Oct 17th, 2006

 

HI Anil,

i don't know Winsql. but my query will works in SQL *plus.

thanks.

Dev.

jamesravid

 Profile Answers by jamesravid 

• Dec 10th, 2006

 

Then try this query,SELECT *FROM (SELECT emp.*, rownum rank FROM emp)WHERE rank BETWEEN 2 AND 3Regards,James.

Imran_Javed

 Profile Answers by Imran_Javed 

• May 9th, 2008

 

SELECT
  *
FROM
  (SELECT empno,  ename,  sal ,
  rank() over(ORDER BY empno) e FROM emp)
WHERE
  e IN (2,3);

sau326

 Profile Answers by sau326 

• Jul 18th, 2010

 

SELECT TOP 2 employeenumber FROM employees WHERE employeenumber NOT IN(SELECT TOP 1 employeenumber FROM employees)

Regards,

Saurabh