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

What is an inner join sql?

694


Explain the difference between sql and mysql.

753


Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

869


What is rename in sql?

726


How to run pl sql program in mysql?

681






What is sql and its types?

813


What is AUTH_ID and AUTH_USER in pl/sql ?

1936


What is update query?

711


What does bitemporal mean?

761


Which sql statement is used to delete data from a database?

651


Is oracle and sql same?

745


Mention what are the benefits of pl/sql packages?

733


Can a key be both primary and foreign?

718


Does a primary key have to be a number?

688


What are the different parts of a package?

810