/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

3 votes209 views2 answers
Update part of a string in mysql
SQL
1 vote194 views2 answers
Find a column in all tables mysql
SQL
0 vote185 views1 answer
Why mysql is used?
SQL
4 votes196 views3 answers
Mysql update with join
SQL
0 vote189 views1 answer
SQL isnumeric DB2
SQL
16 votes204 views6 answers
Install sqlite3 python
SQL
18 votes194 views6 answers
Mysql create table
SQL
1 vote243 views1 answer
Delete dublicate rows sql
SQL
0 vote205 views1 answer
Oracle tablespace autoextend
SQL
14 votes191 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL