How to Select 38th row details in table without using rownum ?

Categories >> ERRORS >> Database Errors >> Oracle Errors
Suggest New Category

Question Posted / nvsubbareddy

12 Answers
16318 Views
ProKarma, Sapient, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to Select 38th row details in table without using rownum ?..

Answer / narsimharaju

By using cursors we can resolve this problem..

Is This Answer Correct ?

12 Yes

1 No

How to Select 38th row details in table without using rownum ?..

Answer / gaurav kumar

SELECT * FROM table LIMIT 37,1;

Is This Answer Correct ?

7 Yes

1 No

How to Select 38th row details in table without using rownum ?..

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

How to Select 38th row details in table without using rownum ?..

Answer / sama

select * from table_name order by some_column LIMIT 1 OFFSET 37;

Is This Answer Correct ?

1 Yes

1 No

How to Select 38th row details in table without using rownum ?..

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

How to Select 38th row details in table without using rownum ?..

Answer / sushant

select * from(
select rownum num, e.* from emp e)
where num=38;

Is This Answer Correct ?

0 Yes

1 No

How to Select 38th row details in table without using rownum ?..

Answer / love

Select * from <tablename> where sno<37 | sno>39

Is This Answer Correct ?

9 Yes

14 No

How to Select 38th row details in table without using rownum ?..

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

How to Select 38th row details in table without using rownum ?..

Answer / ramravi

i am not able to say

Is This Answer Correct ?

4 Yes

13 No

How to Select 38th row details in table without using rownum ?..

Answer / ramravi

i ain't able to say

Is This Answer Correct ?

2 Yes

15 No

Post New Answer