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 |
How to solve S0C7 abend with out using DISPlay in 10 mins?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
Which is faster delete or truncate?
explain about index with examples
How could one combine a set of incremental image copies into a single copy?
How to resolve -917 sql code in DB2?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
How does cobol compile db2 program?
What is the difference between oracle and db2?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.