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

Can we use delete in merge statement?

1030

What are the different types of dbmss?

999

how to get a list of indexes of an existing table? : Sql dba

948

What is the difference between jpql and sql?

1074

what is not null constraint? : Sql dba

1007

What makes a good primary key?

1015

Why sql query is slow?

974

discuss about myisam key cache. : Sql dba

1005

What is pl sql script?

1011

Explain scalar functions in sql?

1045

How can I delete duplicate rows?

995

How do you know if a relationship is 2nf?

926

what is blob? : Sql dba

1121

What is the usage of the distinct keyword?

1199

How is debugging done?

958