how u can find the n row from a table?
Answers were Sorted based on User's Feedback
Answer / a.brahmam
select * from(select rownum r,column name,from table name)
where r=&n;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rashmi
select max(rownum) from table1 where rowid is not null
Is This Answer Correct ? | 2 Yes | 3 No |
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 |
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 |
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 |
Answer / karunakar
select *
from employees
where rowid=(select max(rowid) a
from employees)
Is This Answer Correct ? | 1 Yes | 5 No |
Answer / monika
select employee_id,last_name,salary
from employees
where rownum < n
ORDER by salary
Is This Answer Correct ? | 0 Yes | 11 No |
What does t sql mean?
What does dml mean?
Does sql profiler affect performance?
How to display Row Number with Records in Oracle SQL Plus?
Is drop table faster than truncate?
How many types of normalization are there?
How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).
What is mutating table error?
What is autocommit sql?
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?
package specification-3 procedures package body-2 procedures will is execute
What is fmtonly in sql?