Explain the use of the WHERE clause?
Answer / ms.stanley
WHERE is used to specify the SEARCH ARGUMENT Values in the
SQL Query to retrieve only selected Data from the DB2 Table
| Is This Answer Correct ? | 1 Yes | 0 No |
Before you give the explain statement, what are the prerogatives?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
Can we use select * statement in cobol program without giving field names ???
Explain about rct in db2?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
How to rename a table in DB2 ?
Explain an outer join?
What are the 2 sqlcodes that are returned?
What is the difference between oracle and db2?
What is the difference between TYPE 1 index & TYPE 2 index
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....