The WHERE clause

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

Question Posted / anup

6 Answers
13992 Views
HCL, I also Faced
E-Mail Answers

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 db journal file?

956

What are the different types of dbms?

954

Which is faster subquery or join?

1144

What are the two types of cursors in pl sql?

1002

What is embedded sql with example?

985

Is keyword pl sql?

931

How do I run sql?

1093

Explain the uses of control file.

991

What does := mean in pl sql?

990

What are sql functions? Describe in brief different types of sql functions?

1010

what is a composite key ? : Sql dba

994

what are the performance and scalability characteristics of mysql? : Sql dba

943

Does truncate remove indexes?

970

How do you update a value in sql?

985

How to run sql*plus commands in sql developer?

1085