/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 vote281 views2 answers
Homebrew nysql launch
SQL
5 votes278 views5 answers
Find max number in sql
SQL
1 vote246 views1 answer
Mysql select row with max value group by
SQL
0 vote293 views1 answer
Mysql grant all on all databases
SQL
0 vote256 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote281 views1 answer
Closure in sql
SQL
3 votes280 views1 answer
Postgresql today - 1 year
SQL
0 vote274 views1 answer
Select multiple row from primary key sql
SQL
8 votes267 views1 answer
Show mysql user table
SQL
0 vote265 views1 answer
Best way to bind parameters to SqlCommand C#
SQL