/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 vote263 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote254 views1 answer
Sql get user account
SQL
0 vote238 views1 answer
Get number of table colums in sql query
SQL
0 vote298 views1 answer
Sql pivot without aggregate
SQL
12 votes271 views1 answer
Script to add new column in table sql
SQL
0 vote257 views1 answer
Comma seperated join mssql
SQL
2 votes255 views3 answers
Replace null in sql
SQL
0 vote248 views1 answer
Sqldf change user
SQL
2 votes263 views1 answer
Brew start postgres manual
SQL
0 vote276 views2 answers
CREATE OR REPLACE FUNCTION
SQL