-- 上面的写法,等同于下面的写法,尽量使用上面的写法,不推荐下面的写法
SELECT NORMAL_FILE_NAME,STD_DOC_CODE,STD_DOC_NAME from MED_FILE_STD_REF WHERE !ISNULL(STD_DOC_CLASS_NAME)
GROUP BY STD_DOC_CLASS_NAME DESC
SELECT NORMAL_FILE_NAME,STD_DOC_CODE,STD_DOC_NAME from MED_FILE_STD_REF WHERE !ISNULL(STD_DOC_CLASS_NAME)
GROUP BY STD_DOC_CLASS_NAME
ORDER BY STD_DOC_CLASS_NAME DESC