Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


select 100 records from million records ?

Answers were Sorted based on User's Feedback



select 100 records from million records ?..

Answer / prachi

SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;

This will fetch 1st 100 records

Is This Answer Correct ?    20 Yes 0 No

select 100 records from million records ?..

Answer / ankit.:-)

if u want to fetch first 100 go for

select * from tablename fetch only 100 rows;

this will select only 100

Is This Answer Correct ?    5 Yes 5 No

Post New Answer

More DB2 Interview Questions

Is db2 relational database?

0 Answers  


What is a view? Why use it?

2 Answers  


What is a DB2 plan?

8 Answers  


How to view db2 table structure?

0 Answers  


how can u understand the end of the table ?

1 Answers   TCS,






i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


Explain db2.

0 Answers  


What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


What is scrollable cursor in db2?

0 Answers  


Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,






Categories