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

How does a self join work?

522


Why is a trigger used?

531


Is sql low level language?

579


What are inner outer left and right joins in sql?

519


What is the most common sql injection tool?

547






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

530


Can we use rowid as primary key?

548


what are myisam tables? : Sql dba

552


What is sql query limit?

512


what is oracle database ? : Sql dba

562


Why do we create stored procedures & functions in pl/sql and how are they different?

507


What is a crud api?

502


What are all the different normalization?

565


What is pl sql commands?

558


Which is faster count (*) or count 1?

544