find the customer who placed maximum numbers of orders in sql

Question

1.00/5 (3 votes)

See more:

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.

Posted 19-Oct-14 0:23am

Member 10689154

Updated 28-Jun-22 22:26pm

v2

Add a Solution

4 solutions

Solution 3

Try
Tble..Order
OrderId|CustomerId

SQL

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

Posted 19-Oct-14 20:54pm

/\jmot

Solution 4

select * from(SELECT customerid,COUNT(orderid)
FROM table name
GROUP BY customerid
ORDER BY COUNT(orderid) DESC ) a
WHERE rownum = 1

Posted 28-Jun-22 22:26pm

Member 15690950

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-10-19T00:31:00

Solution 1

Try this:

SQL

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

Now, you need to find maximum value ;)

Posted 19-Oct-14 0:31am

Maciej Los

Comments

Garth J Lancaster 19-Oct-14 6:40am

bvgger - got there before me :-) - I was going to suggest top/limit

Maciej Los 19-Oct-14 6:42am

;)

Member 10689154 19-Oct-14 7:07am

thanks i have done it

Maciej Los 19-Oct-14 7:14am

Please, accept my answer as a solution (green button) - formally, to remove question from unanswered list.

Member 10689154 19-Oct-14 6:46am

how i find the maximum value

Maciej Los 19-Oct-14 6:53am

Via using MAX() function.

George Jonsson 19-Oct-14 7:58am

In Sweden we call this Curling kids, because their parents swiped their path to make it easy to go forward. :)

Maciej Los 19-Oct-14 8:09am

Good one! I need to remember it.
In Poland, when a helpless person needs the parents help (or anybody else), we call it: mummy's boy (mama's boy).

OriginalGriff · Accepted Answer · 2014-10-19T00:33:00

Solution 2

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!

Posted 19-Oct-14 0:33am

OriginalGriff

Comments

Member 10689154 19-Oct-14 6:51am

i think you don't know the answer.

OriginalGriff 19-Oct-14 7:02am

Nice try.
I do - but so should you...