/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

9 votes289 views5 answers
Laravel to sql
SQL
1 vote268 views1 answer
Mysql get latest duplicate rows
SQL
0 vote266 views1 answer
Unique index in mysql
SQL
0 vote289 views1 answer
Wordpress database query change url
SQL
0 vote292 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote287 views1 answer
Sql server Cost Fifo query
SQL
1 vote259 views2 answers
Mysql order by date asc null last
SQL
1 vote272 views1 answer
Postgres concat_ws
SQL
0 vote251 views1 answer
Mysql group rows with same value
SQL
4 votes281 views3 answers
Is not null sql
SQL