Hi.
If exists a table with this description
CREATE TABLE TBL_EMPLOYEES(
EMPLOYEE_ID INT NOT NULL IDENTITY
, NAME VARCHAR(300)
, JOB VARCHAR(50)
, COMISSION FLOAT
, CONSTRAINT PK_EMPLOYEE PRIMARY KEY (EMPLOYEE_ID)
)
And
when you run the data selection is obtained
SELECT * FROM TBL_EMPLOYEES
EMPLOYEE_ID NAME JOB COMISSION
1 JOHN MANAGER NULL
2 CLARK SALES NULL
The query for data with the conditions set forth
SELECT
EMPLOYEE_ID
, NAME
, JOB
, CASE
WHEN JOB = 'MANAGER' THEN 1000
ELSE COMISSION
END COMISSION
FROM TBL_EMPLOYEES
And this is the result:
EMPLOYEE_ID NAME JOB COMISSION
1 JOHN MANAGER 1000
2 CLARK SALES NULL
Regards...