/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

1 vote206 views1 answer
Sql insert for each distinct value
SQL
3 votes240 views1 answer
Sql double index
SQL
0 vote164 views1 answer
Calculate discount from original price sql
SQL
0 vote221 views1 answer
Sql server alter table add column tinyint
SQL
1 vote205 views1 answer
Sql server update column based on another table
SQL
0 vote197 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote205 views1 answer
Tsql pad left
SQL
0 vote211 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote265 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote181 views1 answer
Clone table structure mysql
SQL