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
Answers were Sorted based on User's Feedback
What is trigger types of trigger?
What is difference between nchar and nvarchar?
What is a transaction?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
What is the difference between DELETE, TRUNCATE, and DROP?
what is d diff between grant,commit,rollback n savepoint
Does sap use sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is the difference between partition and index?
What is function and procedure in pl sql?
Why do we need databases?
What found sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)