/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 vote166 views1 answer
Using distinct and count together in sql
SQL
1 vote157 views2 answers
Limit sqlserver
SQL
0 vote128 views1 answer
Concat column value of same user in mysql
SQL
0 vote140 views1 answer
Find number of entries sql
SQL
0 vote139 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote144 views1 answer
Sql query to check if column contains alphabets
SQL
1 vote163 views1 answer
Postgresql datetrunc too slow
SQL
16 votes140 views6 answers
Mysql find and replace
SQL
0 vote153 views1 answer
Select distinct after join
SQL
0 vote164 views2 answers
Insert data mysql with cmd
SQL