select 100 records from million records ?
Answers were Sorted based on User's Feedback
Answer / prachi
SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;
This will fetch 1st 100 records
Is This Answer Correct ? | 20 Yes | 0 No |
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 |
Is ibm db2 free?
What is db2 look?
What are iseries servers?
What is rct?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
Define buffer pool.
what is the name of the default db2 catalog database?
How to find schema of a table in db2?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
What's the maximum number of volumes that can be added to a STOGROUP?
how to fetch multiple records without using cursor