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 / chandrasekar.ramasamy

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

Answer Posted / chandrasekar.ramasamy

The where clause

Is This Answer Correct ?

11 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of join and explain each?

1041

Explain cursor types?

1022

Name three sql operations that perform a sort.

1011

give the syntax of grant and revoke commands? : Sql dba

1149

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

1172

What schema means?

888

How to run pl sql program in mysql?

1020

What are field types?

1004

How many types of normalization are there?

959

Is crud a cuss word?

1032

how many columns can be used for creating index? : Sql dba

946

Does mysql support pl sql?

1168

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1156

What are pl/sql packages?

1102

How do I find duplicates in sql?

929