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 / jyothi
the SET clause
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
How to rename a column in the output of sql query?
Can we use joins in subquery?
How can we store rows in PL/SQL using array?
Why truncate is faster than delete?
Can we use insert statement in function?
State few characteristics of pl/sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Why left join is used in sql?
What does varchar include?
what is a composite primary key ? : Sql dba
What can you do with pl sql?
when MSQL8.0 is in market
Is join an inner join?
What are dml commands?
How do I run a sql trace?