oracle怎么按个数分组
发布网友
共3个回答
热心网友
SELECT MAX(AA.GROUPS), AA.TYPE_ID
FROM (SELECT TRUNC((ROWNUM - 1) / 12) + 1 AS GROUPS,
MAX(A.TYPE_ID) TYPE_ID
FROM TABLENAME A
GROUP BY TRUNC((ROWNUM - 1) / 12) + 1
ORDER BY GROUPS) AA
GROUP BY AA.TYPE_ID
HAVING COUNT(1) > 1;
热心网友
SELECT * FROM ( SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A ) WHERE RN BETWEEN 1 AND 12
热心网友
你的意思是判断不同ID之间的其他数据是否有相同值的么？追问是
