/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 vote320 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote354 views1 answer
Where not in array sql
SQL
0 vote327 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
7 votes339 views2 answers
Oracle sql drop index
SQL
0 vote299 views1 answer
Create dabase postgresql
SQL
0 vote334 views1 answer
Select multiple row from primary key sql
SQL
0 vote326 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote339 views1 answer
Mysql url data type
SQL
1 vote341 views1 answer
Cross schema query oracle 2 users
SQL
1 vote341 views1 answer
Oracle turn off constraint
SQL