Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the use of the WHERE clause.
- 2 Answers
- 5428 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is DB2 (IBM Database 2)?
What is the purpose of rollback and commit?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
what is the process of precompiler?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
What is the difference between db2 and oracle?
What is the clustering index in the db2 database?
What is runstats utility in db2?
What is the maximum number of columns in a db2 table?
What is meant by repeatable read?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
Who uses db2?
COBOL 
