How to Select 38th row details in table without using rownum ?
Answers were Sorted based on User's Feedback
Answer / narsimharaju
By using cursors we can resolve this problem..
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / jilani555
declare
cursor c is select * from emp;
s number:=0;
begin
for i in c loop
s:=s+1;
if s=6 then
dbms_output.put_line(i.empno||' '||i.ename||' '||i.sal);
end if;
end loop;
end;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sama
select * from table_name order by some_column LIMIT 1 OFFSET 37;
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sandipan4allinterview
select * from Table where
(select row(MIN) from Table where
(select top 38 * from Table))
NOTE: This is without using the keyword "rownum" as mentioned in questions..
Code as SQL Server
Is This Answer Correct ? | 4 Yes | 5 No |
Answer / sushant
select * from(
select rownum num, e.* from emp e)
where num=38;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / debasis mohanty
Select * from Table_name
where rownum < 39
MINUS
Select * From Table_name
Where rownum < 38;
Is This Answer Correct ? | 3 Yes | 11 No |
QSM-01049: semi-join check failed for materialized view, string
IMG-00603: unable to access source image data
ORA-23291: Only base table columns may be renamed
PCC-02418: Array size mismatch between Object and REF host variables
ORA-16573: attempt to change configuration file for an enabled broker configuration
ORA-09764: osnmop: access error on oracle executable
ORA-01663: the contents of tablespace 'string' is constantly changing
ORA-21701: attempt to flush objects to different servers
KUP-04080: directory object string not found
ORA-14309: Total count of list values exceeds maximum allowed
ORA-03283: specified datafile string does not exist
ORA-22954: This multiset operation is not supported for this element type.