how to find 5th row ?

Answer Posted / anil

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is log shipping? : Sql dba

619


How to write pl sql program in mysql command prompt?

523


Why coalesce is used in sql?

475


Does truncate free space?

526


What is the difference between a procedure and a function?

503






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

680


Does mysql support pl sql?

632


What is program debugging?

578


What is posting?

616


What is the difference between rename and alias?

717


When can we use the where clause and the having clause?

586


What are the types of join and explain each?

588


Which function is used to return remainder in a division operator in sql?

590


What is a heap in sql?

533


Determine if oracle date is on a weekend?

564