select * from(select rownum as rno,emp.* from emp)where rno=2;

how to retrive only second row from table?

Question Posted / vamsi nukala

Answer Posted / vamsi nukala

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does access use sql?

1018

Can we join same table in sql?

997

What is constant in pl sql?

1005

Is like operator in sql case sensitive?

999

How to combine two stored procedures in sql?

1198

Can we create table in function?

943

What is oracle sql developer?

1029

What does where 1/2 mean in sql?

1048

How to get list of all tables from a database?

1138

How do you rename a table in sql?

1084

what is the difference between myisam static and myisam dynamic? : Sql dba

1050

How many times can we commit in a loop?

998

What does trigger mean in slang?

1032

What are the types of optimization?

928

Which language is used in sql?

1040