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
What is the difference between syntax error and runtime error?
What are the types of functions in sql?
Is oracel sql developer written in java?
What is foreign key sql?
What is raw datatype in sql?
What are aggregate and scalar functions?
What is the difference between view and stored procedure?
What is rownum and rowid?
What is the use of prepared statement?
What is scope and visibility in PL/SQL?
How do I count duplicates in sql?
What is sorting in sql?
What is multiple partition?
What is a sql profiler?
Explain the types of joins in sql?
