找到在sql中放置最大订单数量的客户 [英] find the customer who placed maximum numbers of orders in sql

问题描述

为此写一个sql查询。



找到订购了最多订单的客户


$ b $例如：



有一个名为orders的表，其中有两列。



orderid | customerid

1 --------- 1

2 --------- 2

3 - ------- 3

4 --------- 3





所以这里的答案是customerid = 3.

解决方案

试试这个：

  SELECT  customerid，COUNT（customerid） AS  CountOfCust 
  FROM  TableName 
  GROUP   BY  customerid 

现在，你需要找到最大值;）

我们不做你的功课：它是有原因设置的。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。



亲自尝试，你可能会发现它不是和你想的一样难！

试试

Tble..Order

OrderId | CustomerId

< br $>

 选择  top   1  [CustomerId]，count（[OrderId]） as  NoOfOrders 来自 [dbo]。[tbl_Order]  group   by  [CustomerId] < span class =code-keyword> order   by  NoOfOrders  desc  

write a sql query for that.

find the customer who placed maximum numbers of orders

example :

there is table called orders and in which there are two columns.

orderid|customerid
1 --------- 1
2 --------- 2
3 --------- 3
4 --------- 3


so the answer here is customerid=3.

解决方案

Try this:

SELECT customerid, COUNT(customerid) AS CountOfCust
FROM TableName
GROUP BY customerid

Now, you need to find maximum value ;)

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

Try
Tble..Order
OrderId|CustomerId

select top 1 [CustomerId],count([OrderId]) as NoOfOrders from [dbo].[tbl_Order] group by [CustomerId] order by NoOfOrders desc

这篇关于找到在sql中放置最大订单数量的客户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！