how to retrive only second row from table?

Answer Posted / ehtesham malik

select * from emp
where rowid = (select min(rowid) from emp
where rowid not in (select min(rowid)
from emp)
)

Is This Answer Correct ?    4 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between stored procedure and view?

736


Is nosql faster than sql?

746


What are the different ddl commands in sql?

740


What is the difference between sql and t sql?

717


How does index help in query performance?

763






How many sql statements are used? Define them.

776


what is sql server agent? : Sql dba

772


Explain exception handling in pl/sql?

727


Do foreign keys improve performance?

748


What are secondary keys?

735


What does where 1/2 mean in sql?

762


What is compound trigger?

754


What is the use of desc in sql?

696


What is the purpose of cursors in pl/sql?

798


What is pragma in pl sql?

766