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
14241 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 a unique key and primary key and foreign key?

967

What are different types of indexes?

1004

What is an inconsistent dependency?

1044

What is the basic form of sql query?

938

What is sql*loader and what is it used for? : aql loader

1168

what is subquery? : Sql dba

1125

What packages(if any) has oracle provided for use by developers?

5801

What is write ahead logging in sql server?

1042

How can you create an empty table from an existing table?

1069

What is a database trigger?

1063

Explain the difference between drop and truncate commands in sql?

1035

what's the difference between a primary key and a unique key? : Sql dba

1040

Is sql easier than java?

1004

How do I make sql search faster?

990

What is trigger in sql? Explain

984