How to Select Record with extra text

Mar 23 2021 1:13 PM

how to select record in sql server if i want to select record with EmpId, EmpName,EmpDept from Table.

in EmpDept only 34 department but i want to display one more which is "Other Dept" but "Other Dept" is not is in record.

i dont want to store "Other Dept" in table.

i want to display while execute sql query.

Answers (5)

Group Employee by 2 departments