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

Why we use joins in sql?

540


What are tables in sql?

550


How do you add a column to a table?

602


What packages are available to pl/sql developers?

603


How do sql databases work?

533






Explain correlated query work?

599


What is normalisation and its types?

550


What are the two types of exceptions.

635


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2008


Can two tables have same primary key?

531


Which is faster joins or subqueries?

554


what is index? : Sql dba

558


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1527


Is t sql a programming language?

539


What is the usage of when clause in trigger?

569