/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 vote294 views1 answer
Setval in postgres
SQL
1 vote307 views5 answers
What is in operator in sql
SQL
0 vote291 views1 answer
Change redo log file size in mysql 5.6
SQL
7 votes312 views4 answers
Index in mysql
SQL
0 vote292 views1 answer
Less than date query sqlachemy
SQL
2 votes283 views3 answers
How to pass password mysql command line
SQL
11 votes298 views5 answers
Sql server reset identity
SQL
3 votes275 views1 answer
Oracle apex warning message
SQL
0 vote284 views1 answer
How convert into in in sql query
SQL
17 votes276 views5 answers
Order by sql
SQL