/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 vote179 views1 answer
Import sql in postgresql
SQL
1 vote169 views1 answer
Psql connect to another database
SQL
0 vote163 views4 answers
How to drop all tables in sql
SQL
2 votes163 views3 answers
Postgres remove foreign key constraint
SQL
1 vote176 views1 answer
Oracle sql first day of year
SQL
1 vote169 views1 answer
Count of tables in database mysql
SQL
0 vote187 views1 answer
How to run mysql in git bash
SQL
2 votes184 views1 answer
Compare date in sql
SQL
7 votes160 views1 answer
Append column sql
SQL
0 vote167 views1 answer
Luu ckeditor vao mysql
SQL