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

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

discuss about myisam index statistics collection. : Sql dba

531


What does the acronym acid stand for in database management?

546


what is the difference between clustered and non clustered index in sql? : Sql dba

551


What is difference between my sql and sql?

530


What are the advantages of indexing?

523






What is the process of debugging?

555


Can we call a function containing dml statements in a select query?

546


How do I write a sql query in pgadmin 4?

558


how do you know the version of your mysql server? : Sql dba

506


Why we use pl sql?

531


what are date and time functions in mysql? : Sql dba

536


What is the purpose of a sql?

530


What is sql performance tuning?

497


How to get help at the sql prompt?

645


What is difference between table and view?

526