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
13984 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

how to create a test table in your mysql server? : Sql dba

941

how to present a past time in hours, minutes and seconds? : Sql dba

942

What is AUTH_ID and AUTH_USER in pl/sql ?

2134

What is the syntax and use of the coalesce function?

1094

Why join is faster than subquery?

1039

Explain the purpose of %type and %rowtype data types with the example?

924

What is clause?

1062

How do I run a script in sql developer?

895

how to concatenate two character strings? : Sql dba

1029

What is difference between sql function and stored procedure?

934

How do I clear the screen in sql plus?

978

What is foreign key in sql with example?

889

Does mysql_real_escape_string prevent sql injection?

906

What is the most important ddl statements in sql are?

941

Can unique keys be null?

850