Answer / sunil bisht

Hi Shajin
above answere is perfectly correct.
but i have one more method..


select * from emp where rownum<6 minus select * from emp
where rownum<=4;

Answer / subhani

some of above have used corelated subqueries but it is not
recommonded to use.
best way is
select * from emp where rownum<=5
minus
select * from emp where rownum<5;

Answer / suresh babu

SELECT * FROM t1 a
WHERE 5 = (SELECT COUNT(rowid)
FROM t1 b
WHERE a.rowid >= b.rowid);

This Query,Which is used to find 5 record from Table.

Answer / anil

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

Answer / swastik

SELECT * FROM
          (
           SELECT ROWNUM Rn, E1.*
           FROM Emp
           )
WHERE RN = 5
/

Answer / suresh babu

select * from table_name tn1 where 5 = (select count(rowid)
from table_name tn2 where tn1.rowid >= tn2.rowid);

This query,which is display the 5th row in table.

Answer / bikash khuntia

Hi Freinds,

I have seen the solution given. But in oracle if you will
select records from a table then everytime you will not
fetch the same squence of records. it will come
differently.Hence we cannot select the 5th row from a table
in oracle.

But the solution is that we can select 5th row from a table
in arranging the records in ascending or descending way by
a column and then select the 5th row as below:-

SELECT BIKK.SAL FROM
(SELECT ROWNUM RW,BIK.SAL SAL FROM (SELECT SAL FROM
TEMP_SAL ORDER BY SAL) BIK) BIKK
WHERE rw=6

Answer / alok narayan

1.
select * from emp e1 where 5 =( select count(rowid) from
emp e2 where e1.rowid >= e2.rowid) ;

Answer / krish

select * from(select * from emp order by rowid desc)where
rownum=5;

Answer / sanket.infy

select * from table t1 where rownum = 5 ;

How many clustered indexes can be created on a table?

0 Answers  

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

What is pragma in pl sql?

0 Answers  

What is audit logout in sql profiler?

0 Answers  

What does sign mean sql?

0 Answers  

What is not null in sql?

0 Answers  

Do prepared statements prevent sql injection?

0 Answers  

What is an implicit commit?

0 Answers  

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

Is like operator in sql case sensitive?

0 Answers