Explain the use of the WHERE clause?
- 1 Answers
- 3596 Views
- I also Faced
- E-Mail Answers
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 |
What's the difference between DB2 active log and archive log? Thanks a lot...
Outputs of explain are with matchcols = 0. What does this signify?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What is a predicate?
B37 abend during spufi?
Explain an outer join?
Explain the function done by data manager?
How to resolve -407 sql code in DB2?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
How does DB2 determine what lock-size to use?
What is normalization and what are the five normal forms?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
COBOL 
