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

How delete all records from table in sql?

977

What is a primary key called that is made up of more than one field?

1344

What is difference between primary and secondary key?

1023

What is varchar example?

1023

How show all rows in sql?

1011

Can a foreign key be a duplicate?

906

How do I truncate a sql log file?

1069

How many types of relationship are there?

1027

What is difference between stored procedures and application procedures?

1010

Do we need to create index on primary key?

926

How to run sql statements with oracle sql developer?

1063

How to return multiple rows from the stored procedure?

968

What is sap sql?

976

What is pl sql block in dbms?

1001

what is the difference between char_length and length? : Sql dba

1041