(select * from emp where rownum<3) minus (select * from emp where rownu

how to retrive only second row from table?

Question Posted / rajeev thakur

Answer Posted / rajeev thakur

(select * from emp where rownum<3) minus (select * from emp
where rownum<2);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how many sql dml commands are supported by 'mysql'? : Sql dba

1097

Is pl sql different from sql?

967

What is sqlexception in java?

966

What are three advantages to using sql?

993

how to start mysql server? : Sql dba

1181

Show the cursor attributes of pl/sql.

1026

How do I install sql?

974

Can you have more than one trigger on a table?

985

What is attribute indicator in pl sql?

1000

What is the difference between inner join and natural join?

988

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1022

Explain what is an index?

1034

What is sql and its types?

1155

How many row comparison operators are used while working with a subquery?

1016

how to create a new table by selecting rows from another table in mysql? : Sql dba

1064