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 / anup

The WHERE clause

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why function is used in sql?

522


what is transaction? : Sql dba

532


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

542


What is the difference between union and union all command?

555


What is data definition language?

623






What is a loop in sql?

567


what is the difference between sql and t-sql? : Transact sql

603


What is cursor and its types?

561


how to concatenate two character strings? : Sql dba

553


Explain foreign key in sql?

621


Cite the differences between execution of triggers and stored procedures?

622


Can we insert in view in sql?

568


How do I order by ascending in sql?

542


Write the command to remove all players named sachin from the players table.

738


List out the acid properties and explain?

563