/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 vote3.6K views1 answer
PSQL use LIKE with timestamps
SQL
1 vote178 views1 answer
Oracle convert run duration to number
SQL
5 votes168 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote186 views1 answer
Download sql file of countries names
SQL
8 votes162 views1 answer
Sql limit results returned
SQL
-1 vote160 views2 answers
On update cascade
SQL
3 votes171 views3 answers
Raw select laravel
SQL
0 vote178 views1 answer
Power bi union columns
SQL
5 votes166 views5 answers
Sqlite install python
SQL
4 votes207 views1 answer
How to check last gather stats on table in oracle
SQL