how can we retrieve the 100 records of the file ?

Answer Posted / anjireddy vintha

select * from tabblename where rownum<101

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind plan?

602


What is the purpose of using commit?

607


What language is db2 written in?

590


What is the result of open cursor statement?

627


What is nvl in db2?

618






Explain about dbrm.

601


What is buffer pool and list some of them?

619


Explain correlated sub-queries.

581


What is role in db2?

608


What is a buffer in memory?

587


What is database manager in db2?

542


How is the value function used?

595


How to execute stored procedures?

612


What is dbrm?

632


What does db2 stand for?

593