SQL TIP: UPDATE THE PARTICULAR COLUMN WITH ANY ONE OF SEVERAL VALUES USING CASE
Page 1 of 1 • Share •
SQL TIP: UPDATE THE PARTICULAR COLUMN WITH ANY ONE OF SEVERAL VALUES USING CASE
maran on Mon May 16, 2016 11:15 pm
SQL TIP: UPDATE THE PARTICULAR COLUMN WITH ANY ONE OF SEVERAL VALUES USING CASE
EXAMPLE:
UPDATE SALES SET COMM = CASE DEPTID
WHEN 10 THEN COMM * 5
WHEN 15 THEN COMM * 7
WHEN 20 THEN COMM * 9
END
EXAMPLE:
UPDATE SALES SET COMM = CASE DEPTID
WHEN 10 THEN COMM * 5
WHEN 15 THEN COMM * 7
WHEN 20 THEN COMM * 9
END
maran- Admin
- Posts : 442
Join date : 2009-07-24 
Similar topics» Disrupt Update might Brick your Wii U
» Cannot update Router Firmware
» Update On Sighting In India
» UPDATE: These are NOT the 4 Best Buy Wii U demos !
» Exercise and migrain update
» Cannot update Router Firmware
» Update On Sighting In India
» UPDATE: These are NOT the 4 Best Buy Wii U demos !
» Exercise and migrain update
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|