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
14001 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 example of database?

986

How do I partition in sql?

904

Is coalesce faster than isnull?

909

what is the syntax used for partition in tsql? : Transact sql

960

Why is a trigger used?

890

How many types of keys are there in sql?

988

What does sql stand for?

947

how to load data files into tables with 'mysqlimport'? : Sql dba

1034

What is the current version of postgresql?

1007

What is nosql vs sql?

1123

how does a local variable is defined using t-sql? : Transact sql

950

What is a join query?

908

What is the use of count (*) in sql?

983

How many parts of a pl sql block are optional?

1035

How many types of indexes are there in sql?

935