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 |
how to resolve -811
How many buffer pools are there in DB2?
Where besides the DB2 catalog is database object information stored by DB2?
What is runstats and reorg in db2?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
How to check table size in db2 sap?
How can you get the number of rows impacted by the last executed query?
What is db2 purescale?
Can one database have multiple instances?
how can u nderstand the sql stmts executed successfully or not ?
What is the difference between primary key & unique index ?