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
- 6 Answers
- 12066 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
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is sql and explain its components?
What is primary key and foreign key with example?
What is the difference between count 1 and count (*) in a sql query?
How to run sql functions in pl/sql?
Can ddl statements be used in pl/sql?
What are the different types of tables in sql?
What port does sql server use?
How do you modify a table in sql?
What is interval partition?
How do you drop a trigger?
What is set serveroutput on?
What's the difference between inner join and left join?
What is varray in pl sql?
Can we use pl sql in sql server?
