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 save a sql query?

731


What is count * in sql?

747


What is sql clause?

740


Why schema is used in sql?

724


How do I create a sql script?

761






Define tables and fields in a database

833


What is data profiling in sql?

739


What is the usage of distinct keyword?

815


What are sql objects?

736


What is a null value?

845


how to include numeric values in sql statements? : Sql dba

768


Is sql a microsoft product?

692


What are the features of pl sql?

767


Which constraints we can use while creating database in sql?

790


What are pl/sql cursors?

728