/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

8 votes241 views3 answers
SQL column name
SQL
0 vote258 views2 answers
Mysql missin expression near on
SQL
11 votes235 views1 answer
Oracle insert into where
SQL
0 vote230 views1 answer
Oracle sql number to varchar2
SQL
2 votes242 views2 answers
Storing timezones in postgres
SQL
1 vote252 views1 answer
Postgresql append array
SQL
1 vote213 views4 answers
Fatal database postgres does not exist
SQL
0 vote226 views1 answer
Sql contains numeric characters
SQL
0 vote222 views1 answer
Jooq replace
SQL
11 votes290 views2 answers
Import mysql dump command line windows
SQL