1)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 / tulsi

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

Answer Posted / tulsi

1)THE WHERE CLAUSE

Is This Answer Correct ?

21 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we solve sql error: ora-00904: invalid identifier?

1245

What is a scalar value in sql?

1070

Can a table contain multiple primary key’s?

1093

Explain foreign key in sql?

1018

What is the sql query to display the current date?

1039

explain the delete statements in sql

1043

What is clustered index sql?

984

What is difference between table and view?

1048

Can you have more than one trigger on a table?

997

Is primary key clustered or nonclustered?

1007

List and explain the different types of join clauses supported in ansi-standard sql?

1352

Does truncate table reset auto increment?

989

Explain 3 basic parts of a trigger.

1304

How many rows can sqlite handle?

1106

What is the most restrictive isolation level? : Transact sql

1081