/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

1 vote154 views1 answer
Oracle lowercase
SQL
0 vote162 views1 answer
Oracle c# multiple update sql
SQL
2 votes190 views1 answer
Select a certain number of entries from select mysql
SQL
3 votes152 views2 answers
Postgres inner join vs join
SQL
20 votes170 views5 answers
Reset auto increment mysql
SQL
1 vote143 views1 answer
Error code 1175 mysql fix
SQL
24 votes171 views4 answers
Mysql datetime
SQL
8 votes148 views2 answers
Mysql get first x characters
SQL
0 vote121 views1 answer
Oracle sql replace string in clob
SQL
1 vote188 views2 answers
Install sql server management studio ubuntu
SQL