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 |
Why is pl sql used?
What is oracle sql called?
What is pessimistic concurrency control? : Transact sql
what is self join and how it works??
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
what is a trigger? : Sql dba
What is a nested table in word?
wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?
4 Answers Oracle, TCS, Tecnics,
1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?
What are the different set operators available in sql?
What is the use of desc in sql?
How to run pl/sql statements in sql*plus?