how u can find the n row from a table?
- 19 Answers
- 24283 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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
How do sql triggers work?
How many types of triggers are there in pl sql?
how is myisam table stored? : Sql dba
What is a temporal data type?
What are the possible values that can be stored in a boolean data field?
What is the clause we need to add in function body to return variable?
Advantages and disadvantages of stored procedure?
What are the different types of constraints?
what is a field in a database ? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
Which is the correct statement about truncate and delete?
What is posting?
how to enter characters as hex numbers? : Sql dba
How to take user input in pl sql?
Is pl sql a scripting language?
