Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.5k views
in Technique[技术] by (71.8m points)

sql查询问题 返回结果集或者参数

问题描述:
sql查询,如果结果集不为空则返回结果集。如果结果集为空,则返回查询参数?

说明如下:

SELECT CASE 
        WHEN a IS NULL THEN '${k}'
        ELSE a
    END AS a;

(SELECT a
FROM A

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

为什么要用数据库承担这些,你这个在代码逻辑里面实现才是正道


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...