/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

18 votes148 views4 answers
Mysql current date between two dates
SQL
0 vote141 views1 answer
Limiting query result using where in sql
SQL
0 vote172 views1 answer
Sql server pivot rows to columns
SQL
5 votes166 views1 answer
AND OR NOT operators sql
SQL
1 vote148 views1 answer
Sql server datetime vs datetime2
SQL
1 vote159 views2 answers
Oracle create synonym
SQL
0 vote159 views1 answer
Create table split string function in sql server
SQL
0 vote157 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
6 votes159 views4 answers
Mysql group by date
SQL
0 vote160 views1 answer
Oracle calculate statistics on partition
SQL