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

What is the difference among union, minus and intersect?

1049

State some properties of relational databases?

1115

What are different types of indexes?

1057

Where do we use pl sql?

1052

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

1393

List the various privileges that a user can grant to another user?

1092

What is execute immediate?

1163

Can we use threading in pl/sql?

1096

How to Execute a Package in PL/SQL.?

1286

What are the differences between implicit and explicit cursors?

1110

What are pl sql data types?

1056

how to shut down the server with 'mysqladmin'? : Sql dba

1051

Does a primary key have to be a number?

1003

What is partition by in sql?

1127

What does pragma mean?

1131