/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 vote374 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote363 views3 answers
Sql server import json
SQL
0 vote341 views1 answer
Codeigniter dbforge add index
SQL
0 vote381 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote397 views1 answer
Apt install sql server
SQL
0 vote346 views1 answer
Postgres sql alter table delete row
SQL
0 vote361 views1 answer
Change magento database url usimg musql
SQL
0 vote385 views1 answer
Declare or use variable in snowflake
SQL
3 votes380 views2 answers
Mysql update row
SQL
0 vote436 views1 answer
Mysql show schema
SQL