/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 vote409 views1 answer
Postgresql custom order by
SQL
1 vote370 views1 answer
Oracle drop chain step
SQL
1 vote403 views1 answer
Alter database datafile maxsize 32g
SQL
6 votes353 views2 answers
Mysql check auto increment value
SQL
8 votes380 views1 answer
How to check mysql version in xampp
SQL
0 vote362 views2 answers
How to use aggregate functions in sql
SQL
16 votes392 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote357 views1 answer
Postgresql remove new line from string
SQL
5 votes352 views2 answers
Oracle show procedures
SQL
1 vote338 views1 answer
Mysql select utc time in eastern time
SQL