Answer Posted / monika
SELECT * FROM(SELECT a.*,row_number() over(ORDER BY NULL)
rn FROM emp a)
WHERE rn=2
Is This Answer Correct ? | 18 Yes | 6 No |
Post New Answer View All Answers
How many columns should be in an index?
What is oracle and pl sql?
How do you concatenate in sql?
What is the use of %rowtype?
What is a recursive stored procedure?
what is not null constraint? : Sql dba
Why join is faster than subquery?
What is acid property in a database?
how to calculate expressions with sql statements? : Sql dba
What is not null in sql?
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...
how to select unique records from a table? : Sql dba
How do I make sql search faster?
How do you write an inner join query?
What are inner outer left and right joins in sql?