sqlite:有没有办法在SELECT子句中创建条件OR / COALESCE?
发布时间:2020-12-12 18:51:31 所属栏目:百科 来源:网络整理
导读:我有以下观点: CREATE VIEW FilmTableView AS SELECT (TitleSP || " / " || TitleEN) as Title,CompanyName,CoverURI,CompanyFilmRelation.CompanyId,CompanyFilmRelation.FilmId FROM Film JOIN CompanyFilmRelation on CompanyFilmRelation.FilmId = Film
我有以下观点:
CREATE VIEW FilmTableView AS SELECT (TitleSP || " / " || TitleEN) as Title,CompanyName,CoverURI,CompanyFilmRelation.CompanyId,CompanyFilmRelation.FilmId FROM Film JOIN CompanyFilmRelation on CompanyFilmRelation.FilmId = Film.FilmId JOIN Company on CompanyFilmRelation.CompanyId = Company.CompanyId ORDER BY Title; 但我最终可能会得到TitleSP或TitleEN为空的记录.在这种情况下,我只想包含哪个列不为null而不包含“/”. 有没有办法做到这一点?也就是说,遵循以下逻辑: if(TitleSP && TitleEN) select (TitleSP || " / " || TitleEN) as Title else select (TitleSP ? TitleSP : TitleEn) as Title 解决方法SELECT CASE WHEN (TitleSP = '' OR TitleSP IS NULL) THEN COALESCE(TitleEN,'') WHEN (TitleEN = '' OR TitleEN IS NULL) THEN TitleSP ELSE (TitleSP || ' / ' || TitleEN) END AS Title,... (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |