/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 vote201 views1 answer
Drop procedure sql
SQL
0 vote271 views1 answer
Mysql row generator
SQL
0 vote222 views1 answer
Oracle list datafiles
SQL
0 vote155 views2 answers
Postgresql could not start server mac
SQL
15 votes269 views4 answers
Export mysql db using command line
SQL
4 votes229 views6 answers
Select sql
SQL
0 vote207 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote196 views1 answer
Not between mysql
SQL
1 vote193 views1 answer
Sqlalchemy order_by
SQL
21 votes199 views6 answers
Docker run mysql
SQL