/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 vote363 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote356 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote333 views1 answer
Full syntax inner join
SQL
11 votes406 views2 answers
Having clause in sql
SQL
0 vote386 views2 answers
Generate sql trigger through ef migration
SQL
4 votes366 views3 answers
Employee name starting with in sql
SQL
0 vote430 views1 answer
Delete hangfire retries list
SQL
0 vote374 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote355 views1 answer
Oserror mysql_config not found virtualenv
SQL
7 votes376 views5 answers
Sql remove spaces
SQL