/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 vote256 views1 answer
Get total and distict row diff in sql
SQL
0 vote192 views1 answer
Alter session set nls_language french
SQL
0 vote230 views1 answer
How to start my sql server on mac
SQL
0 vote222 views1 answer
Flush user resource mysql
SQL
1 vote204 views1 answer
Sql only five first row
SQL
0 vote239 views1 answer
Run sql script file and changes db name in this file using c#
SQL
1 vote223 views2 answers
Sql queries practice
SQL
0 vote230 views1 answer
Start stop mysql linux
SQL
0 vote214 views1 answer
Inner join distinct
SQL
1 vote201 views1 answer
Foreign key constraint in ms sql
SQL