/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

2 votes142 views3 answers
Replace null in sql
SQL
0 vote132 views1 answer
Snap craft
SQL
1 vote130 views1 answer
Where date = max(date) in sql
SQL
2 votes132 views1 answer
Q operator in plsql
SQL
1 vote144 views1 answer
Sql how to replace full stop
SQL
0 vote148 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote132 views1 answer
Temp table vs variable table in sql server
SQL
0 vote94 views1 answer
Como leer datos de mysql esp32
SQL
0 vote130 views2 answers
Imageview setimageresource null
SQL
25 votes123 views1 answer
Mysql grant all privileges to a user
SQL