1)With commas (SET price = 0, status = 'I')

How are multiple column = value pairs delimited in the SET
clause of an UPDATE statement?

1. With commas (SET price = 0, status = 'I')
2. With parentheses (SET (price = 0) (status = 'I'))
3. With double-pipes (SET price = 0 || status = 'I')
4. With square-brackets (SET [price = 0] [status = 'I']
5. With single or multiple spaces (SET price = 0 status
= 'I')

Question Posted / tulsi

2 Answers
8234 Views
I also Faced
E-Mail Answers

Answer Posted / tulsi

1)With commas (SET price = 0, status = 'I')

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 self join and what is the requirement of self join? : Sql dba

1185

Can a varchar be a primary key?

1044

Explain the difference between 'between' & 'and' operators in sql

1040

What is the plv (pl/vision) package offers?

1110

What are the parameter modes supported by pl/sql?

1147

what are the authentication modes in sql server? : Sql dba

1116

Why having clause is used in sql?

1018

What is denormalization in a database?

1103

What is the command used to fetch first 5 characters of the string?

1460

What is embedded sql with example?

1096

what is a database? : Sql dba

1237

How do I know if I have sql express or standard?

1062

What is the use of prepared statement?

1070

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1080

Is postgresql a nosql database?

1221