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 / abinaya
The ORDER BY clause
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What are sql objects?
How to check if a column is nullable before setting to nullable?
What is difference between function and trigger?
how to convert dates to character strings? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is prepared statement in sql?
What are commit, rollback, and savepoint?
Does truncate need commit?
Which is faster joins or subqueries?
how many triggers are allowed in mysql table? : Sql dba
What are the different types of functions in sql?
How to know the last executed procedure?
What is the difference between pl and sql?
How to get each name only once from an employee table?