/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 vote381 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote378 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote383 views1 answer
Sql int vs integer
SQL
1 vote411 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote366 views3 answers
CONTACT FORM SQL
SQL
0 vote324 views1 answer
Count the table indatabase
SQL
1 vote369 views1 answer
Mysql text to decimal
SQL
0 vote333 views1 answer
Update database collation in postgresql
SQL
0 vote340 views3 answers
Average salary in sql
SQL
24 votes345 views4 answers
Delete db postgres
SQL