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
13979 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

Can we use two order by clause in query?

916

What is the sql query to display the current date?

988

Is primary key clustered index?

892

how can we know the number of days between two given dates using mysql? : Sql dba

990

Can I learn sql in a week?

1002

what is denormalization. : Sql dba

1037

Is a secondary key the same as a foreign key?

952

What are stuff and replace function?

1012

Does sql profiler affect performance?

939

What are the different types of triggers?

1049

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1037

How do I find duplicates in a single column in sql?

951

What is not equal in sql?

998

What is dynamic query?

909

Is sql sequential or random?

980