Sql

IF('expression', 'Result for true',  'result for false')

if condition
then 
	statement;
else if condition
then
	statement;
else condition
	statement;
end if;

PREVIOUS	NEXT

Code Example
Sql :: multiple row primary key
Sql :: how to find table lock and row lock in mysql
Sql :: what is denormalization in sql
Sql :: mysql order by on condition
Sql :: sql count(*)
Sql :: select only distinct values from another table and excluding from current table
Sql :: enum in sql server
Sql :: sql where is not number
Sql :: sql drop all tables
Sql :: sql order of operations
Sql :: sql table alias join
Sql :: SQL Server Splitting a string column into multiple rows, while repeating ID column
Sql :: get specific column in mongodb
Sql :: sum row in sql
Sql :: sqlite create record
Sql :: compare field sql server
Sql :: sqlcmd no headers
Sql :: execution order in sql
Sql :: limit and offset in stored procedure mssql
Sql :: mysql dependency for spring boot
Sql :: oracle merge insert if not exists
Sql :: sql where clause
Sql :: postrgesql concat 2 columns divided by ;
Sql :: take sql dump in to file
Sql :: psql invalid command N
Sql :: systems sql
Sql :: php select data from mysql database without column name
Sql :: drop table oracle
Sql :: join multiple tables in sql
Sql :: not null sql