07 metabase查询-按照条件查询机柜信息

荒先生

已于 2022-02-18 10:53:28 修改

阅读量247

点赞数

分类专栏： metabase实战教程文章标签：数据可视化

于 2022-02-03 15:34:20 首次发布

本文链接：https://blog.csdn.net/qq_16284479/article/details/122776061

版权

metabase实战教程专栏收录该内容

14 篇文章 2 订阅

订阅专栏

SELECT DISTINCT
	sc.id AS `机柜ID`, 
	sc.`code` AS `机柜代码`, 
	sc.remark AS `机柜描述`
FROM
	scada_cabinet AS sc
WHERE
	sc.workshop_id IN (SELECT sw.fid FROM scada_workshop sw WHERE sw.fname = {{WorkshopName}})
ORDER BY
	sc.id ASC

表格形式：

保存：

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

荒先生

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
07 metabase查询-按照条件查询机柜信息

SELECT DISTINCT sc.id AS `机柜ID`, sc.`code` AS `机柜代码`, sc.remark AS `机柜描述`FROM scada_cabinet AS scWHERE sc.workshop_id IN (SELECT sw.fid FROM scada_workshop sw WHERE sw.fname = {{WorkshopName}})ORDER BY sc.id ASC表格形式：保存：...
复制链接

扫一扫