2020年3月30日
having
摘要： select f.folderno from lims_folders f where exists (select 1 from lims_folderservgrp fs where fs.foldersid = f.foldersid HAVING count(1) > 1) 查询出重复数据 阅读全文
posted @ 2020-03-30 16:50 消失的手套 阅读(185) 评论(0) 推荐(0)
sql
摘要： ①待领样（分多种情况，case when 里复杂）SELECT CASE WHEN T6.groupcount > 1 THEN '1' ELSE '0' END ifothers FROM LIMS_folderservgrp T LEFT JOIN LIMS_folders T2 ON T.fo 阅读全文
posted @ 2020-03-30 16:09 消失的手套 阅读(212) 评论(1) 推荐(0)
无锡
摘要： 1.微生物没领样，理化不准领样。领样之后室科室分发 阅读全文
posted @ 2020-03-30 14:14 消失的手套 阅读(101) 评论(0) 推荐(0)