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
- 13019 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / abinaya
The ORDER BY clause
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is microsoft t sql?
How do I make my sql query run faster?
Is join an inner join?
how to convert numeric values to character strings? : Sql dba
Write a query to find the names of users that begin with "um" in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Are dml statements autocommit?
what are set operators in sql? : Sql dba
What is cross join example?
How to call a javascript function from pl sql?
Inline the values in PL/SQL, what does it mean.?
how to rename an existing table in mysql? : Sql dba
how to escape special characters in sql statements? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is sql key?
