I am Having Below Mention Table Where I want to Add column by query which will add one column to table with value against the Other Columns Specific Values
Consider Following Table
Name Toggle Value
Use the CASE statement in your query .
SELECT Name ,Togglevalue, Case WHEN Togglevalue=1 THEN 'ACTIVE' ELSE 'INACTIVE' END as Status FROM YourTable