Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sagar
SELECT * FROM tab a
WHERE :n = (SELECT COUNT(rowid)
FROM tab b
WHERE a.rowid >= b.rowid);
| Is This Answer Correct ? | 14 Yes | 33 No |
Post New Answer View All Answers
Is null operator in sql?
Why are aggregate functions called so?
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 are actual parameters and formal parameters?
What is delimiter sql?
Is sql the best database?
How do you take the union of two tables in sql?
What does the sign mean in sql?
What is union and union all keyword in sql and what are their differences?
What is rowtype?
How many sectors are in a partition?
Is the primary key an index?
What does <> sql mean?
Enlist the characteristics of pl/sql?
What is embedded sql what are its advantages?
