DB2 SELECT EXIST
作用:查询是否存在
SELECT CASE
WHEN EXISTS (SELECT 1 FROM TABLENAME WHERE id = ?
THEN 1
ELSE 0
END
FROM SYSIBM.SYSDUMMY1;
- 如果存在返回1, 如果不存在返回0;
- 当在子查询中查到一条数据,就会停止查询并返回True.
DB2 SELECT EXIST
作用:查询是否存在
SELECT CASE
WHEN EXISTS (SELECT 1 FROM TABLENAME WHERE id = ?
THEN 1
ELSE 0
END
FROM SYSIBM.SYSDUMMY1;