Explain the use of the WHERE clause.

Answers were Sorted based on User's Feedback



Explain the use of the WHERE clause...

Answer / tharanath.n

you can restrict the rows returned from query by using the
where clause,a where clause contain a condition that must
be met, and it directly follows the from clause. if the
condition is true, the row meeting the condition is returned

Is This Answer Correct ?    1 Yes 0 No

Explain the use of the WHERE clause...

Answer / 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

More DB2 Interview Questions

What is cobol db2?

0 Answers  


Describe major components of db2?

0 Answers  


How to execute stored procedures?

0 Answers  


Explain an outer join?

1 Answers  


How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,






Is the primary key a clustered index?

0 Answers  


What does reorg do in db2?

0 Answers  


define clustering index.

0 Answers  


What is bind in db2?

0 Answers  


What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  


How to view db2 table structure?

0 Answers  


What is phantom read in db2?

0 Answers  


Categories