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 is a record in a database?

995

What is sql mysql pl sql oracle?

1028

What is count * in sql?

936

How do I copy a table in sql?

931

What are the different tcl commands in sql?

1106

What is sql and explain its components?

1009

define sql update statement ? : Sql dba

1051

Is big data nosql?

888

What is the difference between Union and Union all. Which is faster.

1342

What is vector point function?

1005

What is a schema sql?

1056

Why do we use %rowtype & %type in plsql?

994

What is rowid in sql?

909

How do you break a loop in pl sql?

989

What is server name sql?

1070