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 |
Can you Average the Characters ?
What is a db2 schema?
What happens to a cursor after a commit?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
How do you insert a record with a nullable column?
How to handle null values in db2
What is meant by a unit of recovery?
Write a query to retrive partial string.
Q4. How will you get the count of record without using COUNT verb in query?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
i want to maintain uniqueness on pdf without make lf??????????
Can I use LOCK TABLE on a view?