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
Which kind of parameters cannot have a default value in pl sql?
What is the basic form of sql query?
Can we use the cursor's to create the collection in PL/SQL?
what are wild cards used in database for pattern matching ? : Sql dba
What is input buffer in sql*plus?
What is a column in a table?
Is like operator in sql case sensitive?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
How do sql triggers work?
How exception handling is done in advance pl/sql?
What does seeding a database mean?
What is the example of procedure?
What is trigger in sql? Explain
What is sql entity?
What do you understand by exception handling in pl/sql?