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

what are the advantages and disadvantages of views in a database? : Sql dba

1074

How many functions are there in sql?

1095

How does a trigger work?

1145

Can we alter stored procedure?

1043

What are character functions?

1141

Explain spool.

1219

What is a function in oracle pl sql?

1098

Can I call a procedure inside a function?

1076

what are properties of a transaction? : Sql dba

1135

What is sorting in sql?

985

The select into statement is most often used to create backup copies of tables or for archiving records?

1116

Why self join is used in sql?

1031

Why do we need cursor in pl sql?

1187

What are dml commands?

1073

What is a relationship and what are they?

1228