SELECT OrderID, Quantity,
CASE WHEN Quantity > 10 THEN "MORE" ELSE "LESS" END as x
FROM OrderDetails;
SELECT OrderID, Quantity,
IF (Quantity > 10, "MORE", "LESS") as x
FROM OrderDetails;
IF condition1 THEN
statements;
ELSEIF condition2 THEN # OPTIONAL
statements;
ELSE # OPTIONAL
statements;
END IF;
The if accept one condition, if this condition is true then the true_value will occur
else the false_value will occur.
IF(condition, true_value, false_value)
Tips : can be to update some data
SELECT user_display_image AS user_image,
user_display_name AS user_name,
invitee_phone,
(CASE WHEN invitee_status = 1 THEN "attending"
WHEN invitee_status = 2 THEN "unsure"
WHEN invitee_status = 3 THEN "declined"
WHEN invitee_status = 0 THEN "notreviwed"
END) AS invitee_status
FROM your_table
SELECT IF(500<1000, "YES", "NO");
-- PL/SQL
BEGIN
IF my_val = 1 THEN [...]
ELSE [...]
END IF;
END;
-- In a query
SELECT CASE WHEN my_col = 1 THEN 'Ok' ELSE 'Ko' END AS my_result;
IF condition THEN
statements;
ELSE
else-statements;
END IF;
Code Example |
---|
Sql :: postgres integer to serial |
Sql :: Add image in MySQL database |
Sql :: how to select random rows from a table |
Sql :: complete date is 1 year or not sql server |
Sql :: mysql function |
Sql :: sql server list database |
Sql :: sql in |
Sql :: mysql import from sql file |
Sql :: sql datitime to date |
Sql :: insert in to table sql |
Sql :: sql select date add day |
Sql :: mysql count rows returned |
Sql :: mysql locate |
Sql :: second highest salary in sql |
Sql :: count occurrences sql |
Sql :: declare value in sql |
Sql :: sql alchemy or |
Sql :: format the money fied with comma in international system using sql |
Sql :: sql left join |
Sql :: oracle group |
Sql :: mysql timezone |
Sql :: oracle list days between two dates |
Sql :: postgresql database url |
Sql :: oracle show errors compilation |
Sql :: sql duplicate a table with data |
Sql :: oracle privileges users |
Sql :: delete table cassandra |
Sql :: sql is null |
Sql :: sql row having max |
Sql :: close external port 3306 with iptables |