/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 vote288 views1 answer
Character count sql
SQL
7 votes321 views5 answers
Max 3 salary in sql
SQL
2 votes334 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote294 views1 answer
Teller stamp , bmo , PDF
SQL
5 votes300 views2 answers
Postgresql insert select
SQL
0 vote357 views1 answer
Python get backup of sql
SQL
0 vote286 views1 answer
Drop all tables db2
SQL
4 votes282 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote294 views3 answers
Query string not ending with with vowels
SQL
0 vote277 views1 answer
How much table store postgres
SQL