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
14272 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 is cte?

975

What is the difference between delete and truncate commands?

1036

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

1101

What is the use of stored procedures?

1044

Is join an inner join?

963

What is attribute indicator in pl sql?

1011

how to use regular expression in pattern match conditions? : Sql dba

1028

how to check myisam tables for errors? : Sql dba

1320

What is a table in a database?

1043

What is sql exception?

966

what are the disadvantages of mysql? : Sql dba

1149

what is the difference between truncate and drop statements? : Sql dba

1116

How bulk collect improves performance?

999

What are sql procedures?

1019

explain mysql aggregate functions. : Sql dba

984