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 are the disadvantages of mysql? : Sql dba

577


Write a sql query to get the third highest salary of an employee from employee_table?

636


How is data stored on a disk?

546


How does a self join work?

522


How many sql commands are there?

677






How do I save the results of sql query in a file?

537


What are joins in sql?

541


how to get help information from the server? : Sql dba

530


Which join is like an inner join?

528


What is sql comments?

654


What are the different sql commands?

525


Describe sql comments?

565


how many ways to get the current time? : Sql dba

530


what are the difference between clustered and a non-clustered index? : Sql dba

529


What are all the different types of indexes?

627