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 image copy in db2?

0 Answers  


What is the physical storage length of date data type?

0 Answers  


What is database alias db2?

0 Answers  


What is the difference between nvl and coalesce?

0 Answers  


what is difference between random and sequence file access

1 Answers   Syntel,


What will the DB2 optimizer do?

2 Answers  


Can you Average the Characters ?

3 Answers  


What is sqlca?

0 Answers  


Explain about open switch business continuity software?

0 Answers  


What is the difference between cursor and select statement?

0 Answers  


how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,


How is the value function used?

0 Answers  


Categories