摘要:
1. 使用 listagg() WITHIN GROUP () 将多行合并成一行(比较常用) 2.导库 --sqlplus --sys/sys as sysdba --删除表空间drop tablespace IDC_DATA including contents; --创建数据表空间create 阅读全文
摘要:
select f.folderno from lims_folders f where exists (select 1 from lims_folderservgrp fs where fs.foldersid = f.foldersid HAVING count(1) > 1) 查询出重复数据 阅读全文
摘要:
①待领样(分多种情况,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 阅读全文