how to find 5th row ?
Answers were Sorted based on User's Feedback
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;
Is This Answer Correct ? | 22 Yes | 3 No |
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;
Is This Answer Correct ? | 11 Yes | 1 No |
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.
Is This Answer Correct ? | 10 Yes | 5 No |
Answer / swastik
SELECT * FROM
(
SELECT ROWNUM Rn, E1.*
FROM Emp
)
WHERE RN = 5
/
Is This Answer Correct ? | 1 Yes | 0 No |
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.
Is This Answer Correct ? | 2 Yes | 2 No |
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
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / alok narayan
1.
select * from emp e1 where 5 =( select count(rowid) from
emp e2 where e1.rowid >= e2.rowid) ;
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / krish
select * from(select * from emp order by rowid desc)where
rownum=5;
Is This Answer Correct ? | 1 Yes | 7 No |
Can a table contain multiple foreign key’s?
What is group function in sql?
Explain the uses of control file.
How can one get sql*loader to commit only at the end of the load file? : aql loader
How do you declare a constant?
What is difference between sql and excel?
How can you create an empty table from an existing table?
What are different types of queries in sql?
What is procedure and function?
What is nvl function?
What is sql injection owasp?
what is the difference between union and union all
14 Answers IBM, Luxoft, Oracle,