Explain the use of the WHERE clause.
Answers were Sorted based on User's Feedback
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 |
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 |
max number of columns in a db2 table?
What is the difference between SYNONYM and ALIAS?
What is the difference between group by and order by?
What is COPY PENDING status?
what is check point and restart Logic ? why do we go for that ??
Suppose if I need to update a column, how you do that using cursor?
How many clustering indexes can be defined for a table?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the purpose of the WHENEVER statement?
what is the difference between join and union?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none