/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 vote312 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote335 views1 answer
Java nosql sort
SQL
1 vote336 views1 answer
Get create table query existing table mysql
SQL
3 votes347 views1 answer
Laravel database Using Named Bindings
SQL
0 vote310 views1 answer
Getting next sequence value jpa postgress
SQL
3 votes336 views1 answer
Oracle sleep
SQL
0 vote322 views1 answer
Is not sql
SQL
1 vote308 views1 answer
Sql get missing id
SQL
0 vote294 views1 answer
Mysql timeout 30 seconds
SQL
1 vote339 views1 answer
Regular expression in sql server
SQL