SQL在Oracle中选择最大月份

17tucs146拉古尔

嘿，伙计们，我正在处理的当前项目有一些问题。该架构是

问题是显示月份和最大租书量时的书数

我能够编写的代码使我获得了最大的书籍数量 select max(count(book_id)) from bookrental.book_rental group by TO_CHAR(rental_start_date,'MON');

当我使用

 select TO_CHAR(rental_start_date,'MON') 
 from bookrental.book_rental group by(TO_CHAR(rental_start_date,'MON'))
 having count(book_id)= (select
            max(count(book_id)) 
           from bookrental.book_rental group by TO_CHAR(rental_start_date,'MON'));

现在，我需要在一个表格中显示月份和书籍数量。我无法同时加入他们的行列。

谁能帮我吗？

scaisEdge

似乎您错过了计数（book_id）

 select TO_CHAR(rental_start_date,'MON') , count(book_id)
 from bookrental.book_rental 
 group by(TO_CHAR(rental_start_date,'MON'))
 having count(book_id)= (
        select
        max(count(book_id)) 
       from bookrental.book_rental 
        group by TO_CHAR(rental_start_date,'MON'));

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。