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

how to retrive only second row from table?

Question Posted / sushma s

Answer Posted / sushma s

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql pronounced sequel or sql?

1339

What view means?

1025

What is pivot query?

1122

What is the difference between a procedure and a function?

1214

what are the disadvantages of mysql? : Sql dba

1209

How do I find duplicates in two columns?

1265

how do you know if your mysql server is alive? : Sql dba

1128

how to use like conditions? : Sql dba

1166

How to move files from one directory to another in pl sql?

1251

What is column?

1033

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3623

What is the difference between distinct and unique in sql?

993

what is a record in a database ? : Sql dba

1105

How many types of normalization are there?

1016

What is sql clause?

1092