SELECT * FROM ( &

how to find 5th row ?

Question Posted / swastik

Answer Posted / swastik

SELECT * FROM
(
SELECT ROWNUM Rn, E1.*
FROM Emp
)
WHERE RN = 5
/

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to dump a table to a file with 'mysqldump'? : Sql dba

1103

What is a scalar value in sql?

1126

What are the two virtual tables available at the time of database trigger execution?

1272

What is left inner join in sql?

1097

What is the unique index?

1111

How to rename a table?

1076

Is join and inner join the same?

1044

define join and explain different type of joins? : Sql dba

1002

What is delimiter sql?

1060

what is an index? : Sql dba

1045

What are the various levels of constraints?

1169

explain the difference between bool, tinyint and bit. : Sql dba

1063

what are date and time functions in mysql? : Sql dba

1028

What are the types of join and explain each?

1102

Is natural join and inner join same?

993