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 are sql stored procedures used?

990

How can I make sql query run faster?

963

What does := mean in pl sql?

991

Does sql support programming?

1008

What is view explain with example?

887

Why is pl sql needed?

877

what are the advantages a stored procedure? : Sql dba

926

How many types of cursors supported in pl/sql?

1095

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

918

what is view? : Sql dba

914

Is record in pl sql?

918

What is pl/sql table? Why is it used?

978

What is fmtonly in sql?

1010

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

951

How many types of normalization are there?

901