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

the SET clause

Is This Answer Correct ?    2 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I view a table in sql?

547


What is sql used for?

647


What is synchronized subquery?

600


What is group function in sql?

543


What are aggregate functions in sql?

633






What is schema in sql?

518


Does sqlite need a server?

543


what is a composite key ? : Sql dba

612


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

530


what are different types of collation sensitivity? : Sql dba

562


What are tables and fields in the database?

556


how to get a list of columns in an existing table? : Sql dba

546


What does trigger mean in psychology?

540


What is a native sql query?

499


Which sql most popular?

567