Explain the use of the WHERE clause.

Answer Posted / s

The WHERE clause only retrieves the rows based on the
predicate coded in the SQL.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How connect db2 database to datastage?

774


What is syscat in db2?

584


How do you find the maximum value in a column in db2?

656


What is host variable?

601


What is cascading rollback?

627






Mention some fields that are a part of sqlca.

608


What is declare cursor?

623


What is dclgen in db2?

684


Why select is not preferred in embedded sql programs?

719


What is rebind in db2?

581


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1943


What is blu acceleration in db2?

612


What is a db2 package?

603


Is it possible to create an Instance in DB2 using DB2 Control Center ?

635


What are db2 tables?

653