Answer Posted / swastik
SELECT * FROM
(
SELECT ROWNUM Rn, E1.*
FROM Emp
)
WHERE RN = 5
/
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How many types of privileges are available in sql?
What is graph sql?
Can we delete column in sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is materialized view. What are different methods of refresh?
what is sql in mysql? : Sql dba
what are date and time data types? : Sql dba
How to disable a trigger name update_salary?
what are different types of keys in sql?
Can you join views in sql?
Which version of sql do I have?
Why partition by is used in sql?
Where do we use pl sql?
What's the difference between a primary key and a clustered index?