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 / 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 %notfound return null after a fetch?

591


which tcp/ip port does sql server run on? : Sql dba

517


Does sql backup shrink transaction log?

553


Define sql delete statement.

566


Why do we use sql constraints?

662






What is record type in pl sql?

548


What does sql stand for?

546


Explain the update statement in sql

562


What is offset and limit in sql?

555


What is dynamic query?

542


What are dml commands?

529


What is an inconsistent dependency?

583


Can we have two clustered index on a table?

566


What is Histogram?

1103


How many types of tables are there?

509