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 inner join return duplicate rows?

974

What is a natural join?

1066

what is meant by nl2br()? : Sql dba

1031

How do you determine the current isolation level? : Transact sql

1152

Where do we use pl sql?

993

What is pivot in sql?

909

How to add, remove, modify users using sql?

1032

Can I learn sql in a week?

1059

How many types of triggers are there in pl sql?

1066

What is cursor in pl sql?

1114

What is rename in sql?

971

how to get help information from the server? : Sql dba

939

what is primary key? : Sql dba

1024

What do you understand by pl/sql packages?

1058

Name some usages of database trigger?

1017