MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: want to count the number of each item sold using sql command
Posted by: sonam srivastava
Date: June 30, 2015 02:47PM

You can use following command line:
SELECT item_name,
count(*)
FROM orders
GROUP BY Item_name
HAVING count(*) > 1
you can also check this for better understanding http://twxdroid.com/blog/mysql.php

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
want to count the number of each item sold using sql command
gaurav singh
June 30, 2015 02:36PM
Re: want to count the number of each item sold using sql command
sonam srivastava
June 30, 2015 02:47PM
Re: want to count the number of each item sold using sql command
DJ L
June 30, 2015 09:26PM
Re: want to count the number of each item sold using sql command
DJ L
June 30, 2015 11:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.