编写查询以显示访问次数第二高的客户名称
select customer_id,count(*) from booking group by customer_id ;
使用此查询，我得到了每个客户的访问次数计数，如下所示
CUSTOMER_ID,COUNT(*)
C001,6
C002,1
C003,1
C004,1
C005,4
但我只想显示c005，因为他已经访问了第二个最大时间
SELECT customer_id, COUNT(*)
FROM booking
GROUP BY customer_id
HAVING COUNT(*) <> (SELECT MAX(t.custCount)
FROM (SELECT COUNT(*) AS custCount
FROM booking
GROUP BY customer_id) t )
ORDER BY COUNT(*) DESC
LIMIT 1
附带说明一下，如果并列第二名，这将不起作用。在这种情况下，可以将以上查询用作WHERE子句中的条件，例如
SELECT customer_id
FROM booking
GROUP BY customer_id
HAVING COUNT(*) = (query given above)
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句