select * from emp where rownum<=2 minus select * from emp where rownum

how to retrive only second row from table?

Question Posted / naresh raju

Answer Posted / naresh raju

select * from emp where rownum<=2
minus
select * from emp where rownum<2

Is This Answer Correct ?

63 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Can you inner join the same table?

991

What is write ahead logging in sql server?

1050

How do I add a primary key to a table?

1042

How does cross join work in sql?

1015

How many primary keys can a table have?

1006

what are the differences between char and varchar? : Sql dba

1070

What is the use of index in sql?

1017

What are the different types of joins in sql?

1787

Explain what is a column in a table?

1107

Is subquery faster than join?

1013

How does an execution block start and end in pl sql?

950

What does t sql mean?

944

What is a call statement? Explain with an example.

1007

How many types of triggers are there in pl sql?

1066

How long will it take to learn pl sql?

936