Which clause of an UPDATE statement allows you to affect
only certain rows of a table?
1. The WHERE clause
2. The SET clause
3. The ROWS AFFECTED clause
4. The ORDER BY clause
Answer Posted / anup
The WHERE clause
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Define tables and fields in a database
What is normalisation and its types?
how can we know the number of days between two given dates using mysql? : Sql dba
What is case function?
What is the purpose of normalization?
explain the delete statements in sql
Mention what plvcmt and plvrb does in pl/sql?
What are the types of views in sql?
What are packages in pl sql and also explain its advantages?
What is sqlca in powerbuilder?
What is the primary key?
When sql appeared?
What are the different types of dbms?
What is the use of primary key?
How do you modify a column in sql?