select
Round(123.456) as 四捨五入1
,Round(123.456,2) as 四捨五入2
,Fix(123.456) as 切捨て
,Format(123456,'#,###') as 数値編集1
,Format(123456,'#,##0') as 数値編集2
,Instr('ABCDEFG','CDE') as 文字列検索
,UCase('abc') as 大文字
,LCase('ABC') as 小文字
,10 MOD 4 as 余り
四捨五入1
四捨五入2
切捨て
数値編集1
数値編集2
文字列検索
大文字
小文字
余り
123
123.46
123
123,456
123,456
3
ABC
abc
2
SQLServer
select
ROUND(123.456,0) as 四捨五入1
,ROUND(123.456,1) as 四捨五入2
,ROUND(123.456,-1) as 四捨五入2
,ROUND(123.456,0,1) as 切捨て1
,ROUND(123.456,2,1) as 切捨て2
,ROUND(123.456,-1,1) as 切捨て3
,PATINDEX('%CDE%', 'ABCDEFG') as 文字列検索
,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
,UPPER('abc') as 大文字
,LOWER('ABC') as 小文字
,10 % 4 as 余り
,REPLACE(CONVERT(VARCHAR(20),CONVERT(money,123456),1),'.00','') as 整数編集
四捨五入1
四捨五入2
四捨五入2
切捨て1
切捨て2
切捨て3
文字列検索
文字列置換
大文字
小文字
余り
整数編集
123
123.5
120
123
123.45
120
3
ABxxxFG
ABC
abc
2
123,456
MySQL
select
ROUND(123.456) as 四捨五入1
,ROUND(123.456,2) as 四捨五入2
,ROUND(123.456,-1) as 四捨五入3
,TRUNCATE(123.456,1) as 切捨て1
,TRUNCATE(123.456,-1) as 切捨て2
,LPAD('ABC','6','0') as 埋め込み1
,RPAD('ABC','6','0') as 埋め込み2
,INSTR('ABCDEFG','CDE') as 文字列検索
,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
,UPPER('abc') as 大文字
,LOWER('ABC') as 小文字
,MOD(10,4) as 余り
PostgreSQL
select
ROUND(123.456) as 四捨五入1
,ROUND(123.456,2) as 四捨五入2
,ROUND(123.456,-1) as 四捨五入3
,TRUNC(123.456) as 切捨て1
,TRUNC(123.456,2) as 切捨て2
,TRUNC(123.456,-1) as 切捨て3
,TO_CHAR(123456,'999,999') as 数値編集
,TO_CHAR(123,'00000') as 先行ゼロ編集
,TO_CHAR(12345,'FM9999999999') as 文字列へ変換
,LPAD('ABC','6','0') as 埋め込み1
,RPAD('ABC','6','0') as 埋め込み2
,POSITION('CDE' in 'ABCDEFG') as 文字列検索
,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
,UPPER('abc') as 大文字
,LOWER('ABC') as 小文字
,MOD(10,4) as 余り
四捨五入1
四捨五入2
四捨五入3
切捨て1
切捨て2
切捨て3
数値編集
先行ゼロ編集
123
123.46
120
123
123.45
120
123,456
123
文字列へ変換
埋め込み1
埋め込み2
文字列検索
文字列置換
大文字
小文字
余り
12345
000ABC
ABC000
3
ABxxxFG
ABC
abc
2
Oracle
select
ROUND(123.456) as 四捨五入1
,ROUND(123.456,2) as 四捨五入2
,ROUND(123.456,-1) as 四捨五入3
,TRUNC(123.456) as 切捨て1
,TRUNC(123.456,2) as 切捨て2
,TRUNC(123.456,-1) as 切捨て3
,TO_CHAR(123456,'999,999') as 数値編集
,TO_CHAR(123,'00000') as 先行ゼロ編集
,LPAD('ABC','6','0') as 埋め込み1
,RPAD('ABC','6','0') as 埋め込み2
,INSTR('ABCDEFG','CDE') as 文字列検索
,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
,UPPER('abc') as 大文字
,LOWER('ABC') as 小文字
,MOD(10,4) as 余り
from dual
