Answer Posted / suresh babu
select * from table_name tn1 where 5 = (select count(rowid)
from table_name tn2 where tn1.rowid >= tn2.rowid);
This query,which is display the 5th row in table.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain the difference between rename and alias?
How can I see all tables in sql?
What is a mutating table and a constraining table?
What is out parameter used for eventhough return statement can also be used in pl/sql?
How does cross join work in sql?
What is optimistic concurrency control? : Transact sql
What are triggers and its types?
Explain the order of sql statement execution?
Why do we use joins?
What is sqlite format?
What is a database? Explain
Is it possible to pass parameters to triggers?
What is sql profiling in oracle?
What is pl sql variable?
what are the differences between char and varchar? : Sql dba