how u can find the n row from a table?
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 |
Post New Answer View All Answers
What is information schema in sql?
What are the different ddl commands in sql?
What trigger means?
difference between anonymous blocks and sub-programs.
What does varchar include?
What is union, minus and interact commands?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is substitution variable in pl sql?
Can we insert delete data in view?
what is 'mysqlshow'? : Sql dba
What is the difference between sum and count in sql?
Write a sql query to convert all character to uppercase after hypen.
How do you optimize a stored procedure query?
What are sql*plus environment variables?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba