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 a field in a database?

566


What is difference between primary and secondary key?

515


What is a primary key example?

511


What is a primary key called that is made up of more than one field?

787


What is file based approach?

487






What is a memo field?

523


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

534


Describe different types of general function used in sql?

530


What is a design view?

518


What is number function in sql?

525


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

527


What is a .db file?

536


What is the limitation on the block size of pl/sql?

527


What is form and report?

516


What does desc stand for?

588