/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 vote113 views1 answer
Trim sql oracle
SQL
0 vote130 views1 answer
Soql user profile
SQL
1 vote126 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote157 views1 answer
Mysql bind-address default value
SQL
0 vote128 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
1 vote123 views2 answers
Postgres cast as decimal
SQL
1 vote120 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote123 views1 answer
Set default value now() date
SQL
0 vote113 views1 answer
Mysql regex exact match
SQL
0 vote130 views1 answer
How to add unique key constraint in mysql
SQL