Interested to Buy Any Domain ? << Click Here >> for more details...
select 100 records from million records ?
- 2 Answers
- 7992 Views
- Verizon, I also Faced
- E-Mail Answers
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 do you resolve -805?
What is the clustering index in the db2 database?
what is rebinding ?
How can you get the number of rows impacted by the last executed query?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is the meaning concurrency in the db2 database?
How to resolve -917 sql code in DB2?
What is check constraint in db2?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is index cardinality?
i want to delete 20th million record how ?
COBOL 
