oracle 选取出现次数最多的前5条数据
摘要:
SELECT *FROM ( SELECT PROJECT_LISTING.MATERIAL, COUNT (*) AS "出现次数" FROM PROJECT_LISTING WHERE PROJECT_LISTING.MATERIAL IS NOT NULL GROU... 阅读全文
posted @ 2014-05-08 11:30 王大王 阅读(2535) 评论(0) 推荐(0)
posted @ 2014-05-08 11:30 王大王 阅读(2535) 评论(0) 推荐(0)