/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 vote129 views1 answer
Eliminar ultimo carcacter mysql
SQL
1 vote153 views3 answers
Postgresql crete view
SQL
0 vote125 views1 answer
Postgres week number
SQL
0 vote149 views1 answer
Calculer pourcentage mysql
SQL
5 votes135 views1 answer
Get column name sql server
SQL
0 vote136 views2 answers
Close external port 3306 with iptables
SQL
-1 vote120 views1 answer
Round up and down sql
SQL
0 vote129 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote128 views1 answer
Pip install mysqlclient error
SQL
0 vote132 views1 answer
Dump db only triggers mysql
SQL