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
Define the select into statement.
What are system versioned tables?
What is compound trigger?
What is the difference between count 1 and count (*) in a sql query?
Is sql free?
What does (+) mean in sql joins?
Can a foreign key be a duplicate?
What is sql and also describe types of sql statements?
what are the nonstandard string types? : Sql dba
Why trigger is used in sql?
What is the unique index?
What is difference between inner join and self join?
What is user in sql?
What is a join?
What is data manipulation language?