/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

4 votes249 views2 answers
Truncate oracle
SQL
10 votes204 views2 answers
Sql where clause multiple values
SQL
0 vote259 views1 answer
SQL Where-Klausel
SQL
0 vote246 views1 answer
Run mysql xampp shell
SQL
0 vote267 views1 answer
Select distinct after join
SQL
13 votes241 views4 answers
Mysql select last 10 rows
SQL
1 vote258 views3 answers
Mysql on delete set null
SQL
2 votes238 views1 answer
Copy all values of a column to another column in sql in same table
SQL
11 votes239 views1 answer
Oracle view ddl
SQL
0 vote244 views1 answer
Copy data from one postgres container to another
SQL