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
- 13008 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar.ramasamy
The where clause
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain two easy sql optimizations.
What is 19 null in sql?
What are actual parameters and formal parameters?
How do I view an execution plan in sql?
How can you load microsoft excel data into oracle? : aql loader
How do I debug a stored procedure?
what are string data types? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
How does one load ebcdic data? : aql loader
How to find 3rd highest salary of an employee from the employee table in sql?
What is bitemporal narrowing?
What is the difference between cluster and non-cluster index?
what is bcp? When is it used?
What are reports usually used for?
How do you rename a table in sql?
