how u can find the n row from a table?
- 19 Answers
- 24265 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
what is isam? : Sql dba
Which is faster joins or subqueries?
What are some emotional triggers?
Explain 3 basic parts of a trigger.
what are the authentication modes in sql server? How can it be changed? : Sql dba
When is the update_statistics command used?
Define the select into statement.
How does cross join work?
Why do we create stored procedures & functions in pl/sql and how are they different?
How do you rank data in sql?
What is time based sql injection?
Differentiate between % rowtype and type record.
What is the mutating table and constraining table?
what is the difference between primary key and unique key? : Sql dba
What is aggregate function in sql?
