Interested to Buy Any Domain ? << Click Here >> for more details...
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's the difference between inner join and left join?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is rownum?
What are the uses of merge?
What is recursive stored procedure?
What is orm in sql?
What is the difference between having clause and where clause?
What's the difference between a primary key and a clustered index?
What does (*) mean in sql?
What do you understand by pl/sql records?
what is try_catch block in procedure
What is Collation Sensitivity ? What are the various type ?
what are string data types? : Sql dba
Is a secondary key the same as a foreign key?
What is natural join in sql?
