1.获取部门数102个 SELECT count(DISTINCT(substr( SELECTORGANNAME,instr(SELECTORGANNAME,'/',-1,1)+1)) ) from TRAIN_CLASS_NOTICE 2.获取最后截取的字段以最后的/为基准 SELECT substr(SELECTORGANNAME,instr(SELECTORGANNAME,'/',-1,1)+1) SELECTORGANNAME FROM TRAIN_CLASS_NOTICE 3.同上 SELECT DISTINCT( substr(SELECTORGANNAME,instr(SELECTORGANNAME,'/',-1,1)+1) )SELECTORGANNAME FROM TRAIN_CLASS_NOTICE 4.查询所有字段 SELECT * from TRAIN_CLASS_NOTICE
字段去重2
最新推荐文章于 2024-03-27 11:00:13 发布