Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
- 4 Answers
- 7777 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
FETCH is used to retrieve a specific row from a result set
of the SELECT query and places them into local variables.
| Is This Answer Correct ? | 2 Yes | 0 No |
FETCH will give only the number of rows equal to the number
specified with FETCH from resultset given by query.
e.g. consider ACCOUNT_MASTER table contains 100 rows.
SELECT *
FROM ACCOUNT_MASTER
FETCH FIRST 10 ROWS ONLY.
Will give only first 10 rows of ACCOUNT_MASTER table from
100 rows of ACCOUNT_MASTER table
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / siri reddy
Inorder to select first n number of rows fetch is used in
conjunction with select statement
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / akviswa
PS: fetch can be used in select only in case of cursor
select
| Is This Answer Correct ? | 0 Yes | 0 No |
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Is there any advantage to denormalizing DB2 tables?
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is IMAGECOPY ?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What is precompiler in db2?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is db2 and what is the use of db2 optimizer?
Explain about mirror activator disk mirroring?
What is catalog database in db2?
COBOL 
