/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

7 votes207 views6 answers
Mysql group concat
SQL
1 vote200 views1 answer
Postgres regex remove special characters
SQL
1 vote193 views2 answers
Sql insert timestamp
SQL
0 vote166 views3 answers
Mysql calculate age from date of birth
SQL
0 vote195 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote161 views1 answer
Hangfire clean script
SQL
8 votes188 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote187 views1 answer
Import database from a file using mysql commandline
SQL
0 vote184 views1 answer
Mysql table variables
SQL
2 votes246 views1 answer
Mariadb json select
SQL