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 is pl sql quora?
What is a table in a database?
How will you distinguish a global variable with a local variable in pl/sql?
Does truncate table reset auto increment?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
What are the different types of sql commands?
What is compound trigger?
What are Lexical Parameters.How They are used in Reports 6i
How is a PL/SQL code compiled?
What is pl sql in oracle?
what are the disadvantages of mysql? : Sql dba