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
14287 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 a scheduled jobs or what is a scheduled tasks? : Sql dba

958

How do rank () and dense_rank () differ?

1044

What is scope of pl sql developer in future?

1018

is it possible to pass an object or table to a procedure as an argument?

1135

Explain mutating table error.

1200

How many primary keys can a table have?

1005

how do you tune the slow running queries in oracle db , explain the methodology

2774

Why do we create views in sql?

1149

What are the dml statements?

1141

What are tables and fields?

1033

What is the best partition size for windows 10?

1001

What does joining a thread mean?

1019

What are the different tcl commands in sql?

1172

what is unique key constraint? : Sql dba

1035

Explain what is a database?

1085