SQL每日一题(20220225)
SQL每日一题(20220629)


SELECT ID, NUM
FROM (SELECT ID, COUNT(ID) AS NUM
FROM (SELECT REQUESTER_ID AS ID
FROM T0107
UNION ALL
SELECT ACCEPTER_ID AS ID
FROM T0107) a
GROUP BY ID
ORDER BY NUM DESC) a
limit 1

WITH A AS (SELECT X.REQUESTER_ID, COUNT(X.REQUESTER_ID) CT
FROM (SELECT T1.REQUESTER_ID FROM T0107 T1 UNION ALL SELECT T2.ACCEPTER_ID FROM T0107 T2) X
GROUP BY X.REQUESTER_ID)
SELECT B.REQUESTER_ID AS "id", B.CT AS "num"
FROM (SELECT A.REQUESTER_ID, A.CT, MAX(A.CT) OVER () MX FROM A) B
WHERE B.CT = B.MX;
本文介绍了如何通过SQL查询找出在T0107表中高频请求者和接受者的ID,涉及UNION ALL操作和窗口函数的应用,展示了数据聚合和排名的技巧。

被折叠的 条评论
为什么被折叠?



