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

What is posting?

619


How to look at the current sql*plus system settings?

612


What is use of trigger?

519


How do I run a query in pl sql developer?

571


What is sql lookup?

516






Write a query to find the names of users that begin with "um" in sql?

517


What is difference between left and right outer join?

532


Is keyword pl sql?

564


What is a mutating table and a constraining table?

580


Why sql query is slow?

583


What are the various restrictions imposed on view in terms of dml?

531


How do I quit sql?

508


What are sql triggers used for?

517


What are the dml statements?

698


what are the limitations of identity column? : Transact sql

612