/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 vote205 views1 answer
Sql server select ignore dupplicates
SQL
6 votes222 views3 answers
Mysql create database utf8
SQL
1 vote203 views1 answer
Sql run multiple updates in one query
SQL
0 vote226 views1 answer
Regex any word except sql
SQL
1 vote202 views2 answers
Drop function in sql
SQL
1 vote189 views1 answer
Firebase bigquery cloud message
SQL
2 votes225 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote285 views1 answer
Sql select max value for each group
SQL
1 vote209 views2 answers
How to search date in sql query
SQL
1 vote292 views1 answer
Oracle select first row order by
SQL