/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 vote336 views1 answer
Postgres can integer fields be negative
SQL
0 vote323 views1 answer
Creation d'un trigger sql
SQL
0 vote308 views1 answer
How to use lower case in mysql
SQL
4 votes350 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote308 views1 answer
Turnicate in mysql
SQL
4 votes312 views2 answers
Sql table
SQL
1 vote342 views1 answer
Mamp mysql path mac
SQL
1 vote314 views1 answer
Oracle sql listagg
SQL
0 vote346 views1 answer
Sql with example
SQL
1 vote349 views1 answer
Nvl postgres
SQL