SQL TIP: UPDATE THE PARTICULAR COLUMN WITH ANY ONE OF SEVERAL VALUES USING CASE
Page 1 of 1
SQL TIP: UPDATE THE PARTICULAR COLUMN WITH ANY ONE OF SEVERAL VALUES USING CASE
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
Similar topics
» CPYTOIMPF and CPYFRMIMPF Supports column headings
» Find all instances of a column names in Database files.
» SQL TIP: To DELETE the records having the duplicate key values
» SQL TIP: FINDING TOTAL NO OF FEMALE AND MALE EMPLOYEES USING CASE
» System Values
» Find all instances of a column names in Database files.
» SQL TIP: To DELETE the records having the duplicate key values
» SQL TIP: FINDING TOTAL NO OF FEMALE AND MALE EMPLOYEES USING CASE
» System Values
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|