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

The ORDER BY clause

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between truncate and drop statements? : Sql dba

554


how to fetch common records from two tables? : Sql dba

633


What is the difference between cluster and non-cluster index?

618


how to include character strings in sql statements? : Sql dba

556


what is a cursor? : Sql dba

557






which types of join is used in sql widely? : Sql dba

542


how would you enter characters as hex numbers? : Sql dba

516


How to rename a table?

558


How do you update sql?

523


What are tables and fields?

593


Can a trigger call a stored procedure?

536


Can we insert data in view?

507


What is an implicit commit?

559


What is trigger and types?

563


Mention what plvcmt and plvrb does in pl/sql?

643