find out the customers having maximum number of unique orders.

  • I have 2 tables with customer id in one coulmn and orderid in another table.

    I need to find out the customers having maximum number of unique orders.

    finf customer 1 has 4 different orders i need to display the count as 4 against customer 1.

  • This sounds a bit like a school work type question so without wanting to give too much of an answer I'd suggest you look at the GROUP BY clause - that should help you find the answer.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply