Answer Posted / suresh babu
SELECT * FROM t1 a
WHERE 5 = (SELECT COUNT(rowid)
FROM t1 b
WHERE a.rowid >= b.rowid);
This Query,Which is used to find 5 record from Table.
Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Can you rollback after commit?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the use of prepared statement?
What is rank function in sql?
What is sql server and ase?
How to find 3rd highest salary of an employee from the employee table in sql?
What is pl sql commands?
how can we destroy the cookie? : Sql dba
what is sub-query? : Transact sql
What is sql injection owasp?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What are the ddl commands?
What is the maximum number of rows in sql table?
How much does a sql dba make? : SQL DBA
what is the difference difference between procedure and packages