phpmyadmin Question posted in
The official documentation can be found here.

I need to find out what the most popular sold product is within my data base, whilst showing the product ID, Name and Quantity sold – Phpmyadmin

Here is an image of my current code

This is what my current code outputs when I enter it

This is what I need my code to be outputting

Tags:

2

Answers


  1. 0

    Seems like you just want the top record.
    For starter, You can append LIMIT 1 at the end of the query. It should give you the top record.

    You can also use aggregation function MAX() for the quantity field to only choose the maximum one.

    Login or Signup to reply.
  2. 0

    If your select statement is working properly, I think you just need to add "limit 1" at the end of your statment.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search