/SQL/Codeigniter 3 get best-selling products

Codeigniter 3 get best-selling products

#You can use a SQL join between the tables on ProID, e.g.
select *
from products as p
inner join orderdetails as od
   on p.ProID = od.ProID
#You can use group by syntax to ensure you get distinct rows, e.g.

group by p.ProID
#Use aggregation function such as sum, count and avg to find out the totals in a select, e.g.

select sum(od.OrderQuantity) as total
#Use order by syntax to show the top answers, e.g.

order by sum(od.OrderQuantity) desc
#Use limit to show top n results, e.g.

limit 5
#Hopefully that gives you enough pointers to formulate the SQL yourself.

#notes, I've given the tables an alias to ensure you don't get conflicts between the column names. You can't reference total in your order statement due to the way SQL calculates the dataset. I've used an inner join, but you might want to look into left & right joins.

Source: stackoverflow.com

Similar codes

0 vote100 views1 answer
How to select only a certain date sql
SQL
13 votes100 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
-1 vote129 views1 answer
Search all sql tables for a value
SQL
2 votes104 views1 answer
Anonymous block plsql
SQL
1 vote108 views1 answer
How to update date add hours in postgresql
SQL
3 votes98 views2 answers
Mysql create database
SQL
9 votes103 views4 answers
SQL Date Format
SQL
2 votes110 views1 answer
Apex execute batch job
SQL
1 vote101 views1 answer
Primary key with prefix sql
SQL
4 votes113 views1 answer
Id increment ms sql server
SQL