sinat_27468401的博客

SELECT a.tablespace_name “表空间名”,total “表空间大小”,free “表空间剩余大小”,(total - free) “表空间使用大小”,total / (1024 * 1024 * 1024) “表空间大小(G)”,free / (1024 * 1024 * 1024) “表空间剩余大小(G)”,(total - free) / (1024 * 1024 * 1024) “表空间使用大小(G)”,round((total - free) / total, 4

数据库查询重复字段sql查询某个字段有重复的数据:select org_id from oa_food_yy group by org_id having count(*)>1查询某些字段有重复的数据:select org_id,food_id from oa_food_yy group by org_id,food_id having count(*)>1select * from oa_food_yy where (org_id,food_id) in (select org_id