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
- 6 Answers
- 12091 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / tulsi
1)THE WHERE CLAUSE
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
What is data control language (dcl)?
How can use stored procedures in sql?
how to shut down the server with 'mysqladmin'? : Sql dba
How do you pronounce sql?
What is pivot query?
What is exception? What are the types of exceptions?
What is Difference Between Unique and Primary Key Constraints?
What is foreign key in sql with example?
How does sql*loader handles newline characters in a record? : aql loader
What is informix sql?
Can a foreign key be a duplicate?
What can sql server reporting services do?
Explain the order of sql statement execution?
What is an intersect?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
