how to retrive only second row from table?

Question Posted / ravi148

Answers were Sorted based on User's Feedback

how to retrive only second row from table?..

Answer / sunita

select * from tab
where rownum=2;

Is This Answer Correct ?

18 Yes

142 No

More SQL PLSQL Interview Questions

What is difference between ms sql and mysql?

What is the need of merge statement?

what are properties of a transaction? : Sql dba

Cite the differences between execution of triggers and stored procedures?

What is the life of an sql statement?

What is the difference between union and union all command?

how to use like conditions? : Sql dba

what's the difference between a primary key and a unique key? : Sql dba

What is query optimization in sql?

How to get help at the sql prompt?

Is nosql relational?

How do I order by ascending in sql?

For more SQL PLSQL Interview Questions Click Here