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» How to update any field(text area) in selenium RC using C#
» Disrupt Update might Brick your Wii U
» [ANSWERED] Windows 8.1 with Update (Retail,Professional VL,Enterprise) (x86/x64) - DVD (English) Out
» [ANSWERED] Cannot Apply Windows Update
» eshop: 1001 Spikes Wii U Update Set To Add Off-TV Play And More Controller Options!
» Disrupt Update might Brick your Wii U
» [ANSWERED] Windows 8.1 with Update (Retail,Professional VL,Enterprise) (x86/x64) - DVD (English) Out
» [ANSWERED] Cannot Apply Windows Update
» eshop: 1001 Spikes Wii U Update Set To Add Off-TV Play And More Controller Options!
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|