how to find 5th row ?

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


Please Help Members By Posting Answers For Below Questions

What is a record in a database?

559


How do you create an update query?

518


how to enter characters as hex numbers? : Sql dba

565


What is the difference between a database and a relational database?

558


Enlist some predefined exceptions?

578






Does view store data in sql?

530


Explain the insert into statements in sql?

561


Is t sql a programming language?

539


what is query cache in mysql? : Sql dba

573


Is sql a dbms?

528


Are stored procedures compiled?

522


Is it possible to read/write files to-and-from PL/SQL?

650


How do I restart sql?

524


what is 'mysqldump'? : Sql dba

567


What are all different types of collation sensitivity?

523