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

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1138

What is delimiter sql?

1007

How do I find duplicates in the same column?

1087

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1129

How do I partition a table in sql?

1131

define sql delete statement ? : Sql dba

1020

Mention what does the hierarchical profiler does?

1090

What are the commands used in sql?

1079

what are the performance and scalability characteristics of mysql? : Sql dba

997

what are wild cards used in database for pattern matching ? : Sql dba

1143

what is timestamp in mysql? : Sql dba

1077

What is mutating error in pl sql?

1020

What if we write return in procedure?

1429

What is before and after trigger?

959

how to get a list of indexes of an existing table? : Sql dba

960