how u can find the n row from a table?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

19 Answers
24266 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how u can find the n row from a table?..

Answer / a.brahmam

select * from(select rownum r,column name,from table name)
where r=&n;

Is This Answer Correct ?

0 Yes

0 No

how u can find the n row from a table?..

Answer / rashmi

select max(rownum) from table1 where rowid is not null

Is This Answer Correct ?

2 Yes

3 No

how u can find the n row from a table?..

Answer / kris17.danger

SELECT * FROM ( SELECT ROWNUM R , A.* FROM TABLE_NAME A )
WHERE R=N;

Herer N is the number of row which need to be find.

Is This Answer Correct ?

0 Yes

1 No

how u can find the n row from a table?..

Answer / manoj gogoi

select a2.*
from
(select rownum r,a1.* from a a1)a2
where a2.r=&Any_Row_U_Want

Is This Answer Correct ?

0 Yes

2 No

how u can find the n row from a table?..

Answer / guest

select rownum,ename,sal,empno from(select ename,sal,empno from
table_name order by sal) group by rownum,ename,sal,empno
having rownum=(select count(*) from table_name

Is This Answer Correct ?

10 Yes

13 No

how u can find the n row from a table?..

Answer / anudeep

select * from employee where rowid=&n;

Is This Answer Correct ?

1 Yes

4 No

how u can find the n row from a table?..

Answer / karunakar

select *
from employees
where rowid=(select max(rowid) a
from employees)

Is This Answer Correct ?

1 Yes

5 No

how u can find the n row from a table?..

Answer / abhi

select * from employee where employeeno="1";

Is This Answer Correct ?

1 Yes

5 No

how u can find the n row from a table?..

Answer / monika

select employee_id,last_name,salary
from employees
where rownum < n
ORDER by salary

Is This Answer Correct ?

0 Yes

11 No

Post New Answer