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 are conditional predicates?
Why select is used in sql?
what is the difference between char and varchar data types? : Sql dba
What are different types of sql?
How do you write an index?
What is a Mapplet?
Where is sql database stored?
Why do we create stored procedures & functions in pl/sql and how are they different?
which operator is used in query for pattern matching? : Sql dba
What is mdb stand for?
Does pl/sql support create command?
what are integrity rules?
What are inner outer left and right joins in sql?
What is the usage of nvl function?
Define join and name different types of joins?
