SELECT ..., CASE WHEN IDParent < 1 THEN ID ELSE IDPArent END AS ColumnName, ... FROM tableName-- In a query (DUAL is for Oracle) SELECT CASE lower(my_col) WHEN 'agree' THEN 'Ok' WHEN 'maybe' THEN 'Wait' ELSE 'Ko' END AS my_result FROM DUAL;
SELECT ..., CASE WHEN IDParent < 1 THEN ID ELSE IDPArent END AS ColumnName, ... FROM tableName-- In a query (DUAL is for Oracle) SELECT CASE lower(my_col) WHEN 'agree' THEN 'Ok' WHEN 'maybe' THEN 'Wait' ELSE 'Ko' END AS my_result FROM DUAL;