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 are the differences between implicit and explicit cursors?

Is sql the best database?

what is cursor procedure

What are some predefined exceptions in pl/sql?

what is bcp? When is it used?

What is primary key and foreign key?

What are two virtual tables available during database trigger execution ?

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

how to present a past time in hours, minutes and seconds? : Sql dba

How to write a query to show the details of a student from students table whose

Which nosql database is best?

What does the acronym acid stand for in database management?

For more SQL PLSQL Interview Questions Click Here