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 / tulsi
1)THE WHERE CLAUSE
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
Can you inner join the same table?
What is latest version of sql?
What are different sql data types?
What is database white box testing and black box testing?
what is a composite key ? : Sql dba
How to avoid duplicate records in a query?
Is a secondary key the same as a foreign key?
What is replication id?
Can one improve the performance of sql*loader? : aql loader
What is a left inner join?
Which is better join or subquery?
What is nosql db?
What happens when a trigger is associated to a view?
how do you know the version of your mysql server? : Sql dba
Difference between global and parameter variables?