3. The ROWS AFFECTED clause

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

Question Posted / vishu

6 Answers
14325 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / vishu

3. The ROWS AFFECTED clause

Is This Answer Correct ?

0 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is type and rowtype in pl sql?

1021

What is the clause we need to add in function body to return variable?

1015

what is 'mysqlcheck'? : Sql dba

1019

What is the left table in sql?

971

what is a trigger in mysql? : Sql dba

1151

Why do we need cursors in pl sql?

1091

Mention what is the plv (pl/vision) package offers?

1108

What is PL/SQL Records?

1197

how to drop an existing table in mysql? : Sql dba

1051

Does execute immediate commit?

1223

How many types of privileges are available in sql?

1351

How is data stored in sql?

1065

Do foreign keys improve performance?

1027

how to drop an existing index in mysql? : Sql dba

1070

what are the types of subquery? : Sql dba

1111