Member Avatar for sathish_nadu

I have the following simple table:

CustomerID  CustomerName   NumOfOrders
1           Joe            15
2           Jane           20
7           Clara          1

I want to find the customer with maximum number of orders. Seems trivial enough but I can,t seem to find a solution.

  • 4 Contributors
  • 5 Replies
  • 112 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by pritaeas

Recommended Answers

All 5 Replies

Member Avatar for pritaeas

Use ORDER BY NumOfOrders DESC LIMIT 1

Member Avatar for ZER09

hello can i intercept this thread?

which is faster select max(NumOfOrders) from table

or

select NumOfOrders from table order by NumOfOrders desc limit 1

Edited by pritaeas because: Added markdown.
Member Avatar for pritaeas

Why don't you profile that query, I think it depends on whether you're using the right index.

Member Avatar for anupamduttabd 
Select Top 1 CustomerID,CustomerName, NumOfOrders from Table order by NumOfOrders desc
Member Avatar for pritaeas

TOP 1 is used in MS SQL Server, not MySQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.