How do you filter out the rows retrieved from a Db2 table ?



How do you filter out the rows retrieved from a Db2 table ?..

Answer / s

use the WHERE Clause

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is REORG? When is it used?

4 Answers  


what are bind concepts in db2 cobol?

0 Answers  


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  


What is the difference between static and dynamic SQL?

1 Answers  


I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,






Is it possible to precompile if db2 goes down?

4 Answers   Target,


How do you select a row using indexes in db2?

0 Answers  


Are views updatable ?

4 Answers  


What will the COMMIT accomplish?

5 Answers  


What is null in db2?

0 Answers  


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


Which isolation level provides highest data integrity?

0 Answers  


Categories