/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

15 votes216 views6 answers
Laravel db transaction
SQL
1 vote248 views1 answer
Sql in array query
SQL
1 vote192 views1 answer
Declare table variable
SQL
20 votes205 views4 answers
Reset auto increment in MySQL
SQL
2 votes187 views1 answer
How to add where command in update comand with joins
SQL
8 votes187 views3 answers
Postgresql connection string c#
SQL
0 vote296 views1 answer
Delet all record statment sql
SQL
1 vote199 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote198 views1 answer
Oracle current timestamp insert statement
SQL
0 vote230 views1 answer
Compare strings lexicographically in sql
SQL