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 |
ORA-30101: unknown parameter name 'string'
ORA-07640: smsget: SGA not yet valid. Initialization in progress
RMAN-20217: datafile not part of the database
PLS-00600: SAMPLE cannot be applied to a remote object
ORA-23317: a communication failure has occurred
ORA-16763: log transport service for some standby database unexpectedly online
ORA-27548: Unable to unprepare IPC buffer
ORA-30191: missing argument list
ORA-13415: invalid or out of scope point specification
NZE-29120: Cannot export certificate.
ORA-04095: trigger 'string' already exists on another table, cannot replace it
RMAN-06464: BACKUP BACKUPSET is not supported with VALIDATE option