/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

2 votes161 views1 answer
Oracle insert or update
SQL
1 vote163 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
16 votes156 views3 answers
Tsql rename column name
SQL
-1 vote162 views1 answer
Mac mysql workbench console
SQL
1 vote153 views1 answer
How to use db.execute
SQL
10 votes161 views6 answers
Sql between
SQL
0 vote162 views1 answer
Sp in sql server
SQL
0 vote159 views1 answer
Resullt all update knex mysql
SQL
0 vote155 views1 answer
How to install sql in anaconda
SQL
3 votes153 views1 answer
Uppercase and lowercase in sql
SQL