how can we retrieve the 100 records of the file ?
Answers were Sorted based on User's Feedback
Answer / lu
your qestion is not clear ??? first 100 rows or 100 rows
any where ??
this is FIRST 100 row :
SELECT * FROM TABLE
FETCH FIRST 100 ROWS ONLY
now if u want retrieve 100 rows in any table, you have to
create a counter ....
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / anjireddy vintha
select * from tabblename where rownum<101
Is This Answer Correct ? | 3 Yes | 4 No |
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
how to resolve -811
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?
What is the difference between Where and Having Clause
Can we install 2 different versions of Db2 on same mainframe?
What is the difference between cursor and select statement?
What is reorg and runstats in db2?
What are delete-connected tables?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is reorg in database?
What is the size of a data page?
On which levels locks can be applied?