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

What is information schema in sql?

1113

What are the different ddl commands in sql?

1251

What trigger means?

1036

difference between anonymous blocks and sub-programs.

1188

What does varchar include?

992

What is union, minus and interact commands?

1364

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1072

What is substitution variable in pl sql?

1107

Can we insert delete data in view?

996

what is 'mysqlshow'? : Sql dba

1073

What is the difference between sum and count in sql?

1036

Write a sql query to convert all character to uppercase after hypen.

1484

How do you optimize a stored procedure query?

1041

What are sql*plus environment variables?

1155

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

998