select * from tab where rownum=2;

how to retrive only second row from table?

Question Posted / sunita

Answer Posted / sunita

select * from tab
where rownum=2;

Is This Answer Correct ?

18 Yes

142 No

Please Help Members By Posting Answers For Below Questions

Why do we use procedures?

909

What are the benefits of stored procedures?

994

What are the different sql commands?

1000

what are date and time data types in mysql? : Sql dba

916

What operators deal with null?

1022

What are tables in sql?

996

Why truncate is used in sql?

932

What are the types of variable use in pl sql?

1006

what is sql profiler? : Sql dba

994

Why cross join is used?

1020

How do you identify a primary key?

1010

What is a primary key example?

899

What is a stored procedure in sql with example?

1052

What is union?

1079

What is cascade in sql?

908