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

What does t sql mean?

529


How do you optimize a query?

534


Describe different types of general function used in sql?

530


What is orm in sql?

533


Can you skip header records while loading? : aql loader

537






What is record in pl sql?

589


What is the function that is used to transfer a pl/sql table log to a database table?

549


What is a heap in sql?

524


What is the difference between instead of trigger and after trigger?

506


Write a query to find the names of users that begin with "um" in sql?

498


Is sql better than access?

536


how to shut down the server with 'mysqladmin'? : Sql dba

539


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

560


Can we delete column in sql?

557


Can %notfound return null after a fetch?

581