Interested to Buy Any Domain ? << Click Here >> for more details...
select 100 records from million records ?
- 2 Answers
- 7842 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 |
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
Can we install 2 different versions of Db2 on same mainframe?
My SQL is not performing well. Describe how will you fine tune it?
What is the difference between base table and view?
What are the advantages of using a PACKAGE?
How do you pull up a query which was previously saved in qmf?
What are the isolation levels possible ?
How do you prepare a COBOL + DB2 program from coading till execution ?
What is the purpose of using commit?
What is dclgen (declaration generator)?
Are view updateable?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
COBOL 
