select * from emp where rownum <=5 minus select * from emp where rownu

how to find 5th row ?

Question Posted / anil

Answer Posted / anil

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

When you have to use a default "rollback to" savepoint of plvlog?

1252

What is cursor status?

1238

How does sql profiler work?

1065

Is sql between inclusive?

1199

What is scope and visibility in PL/SQL?

1291

Is crud a cuss word?

1073

What is the clause we need to add in function body to return variable?

1054

How do you write an inner join query?

996

What are system versioned tables?

1074

What is function and procedure in pl sql?

1119

what is sql in mysql? : Sql dba

1238

What is sql profiling in oracle?

1133

How do I view tables in sql developer?

1009

Where is sql database stored?

1039

What does count (*) do in sql?

1050