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
how to dump a table to a file with 'mysqldump'? : Sql dba
What is a scalar value in sql?
What are the two virtual tables available at the time of database trigger execution?
What is left inner join in sql?
What is the unique index?
How to rename a table?
Is join and inner join the same?
define join and explain different type of joins? : Sql dba
What is delimiter sql?
what is an index? : Sql dba
What are the various levels of constraints?
explain the difference between bool, tinyint and bit. : Sql dba
what are date and time functions in mysql? : Sql dba
What are the types of join and explain each?
Is natural join and inner join same?