select * from ( select rownum r,a.* from TableName a ) where r=n't

how u can find the n row from a table?

Question Posted / santosh dwivedi

Answer Posted / santosh dwivedi

select * from
(
select rownum r,a.* from TableName a
)
where r=n'th

Is This Answer Correct ?

5 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Is grant a ddl statement?

849

What is sql profiler in oracle?

1012

What does the argument [or replace] do?

1014

what is sp_pkeys? : Transact sql

1098

Cite the differences between execution of triggers and stored procedures?

1026

What is sql key?

917

How subquery works in sql?

992

What is view explain with example?

879

what is the difference between group by and order by in sql? : Sql dba

1049

What are sql ddl commands?

1018

Can you have more than one key in a database?

890

What is the sql query to display the current date?

989

What is data type in sql?

918

Can we create table inside stored procedure?

903

Explain what is an index?

994