/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

1 vote134 views6 answers
In sql
SQL
2 votes184 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote143 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote146 views1 answer
Get initial in sql
SQL
0 vote158 views1 answer
Python sqlalchemy connection show server
SQL
0 vote100 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote93 views0 answer
SQL
0 vote154 views1 answer
Sql query to return field name of a table
SQL
1 vote155 views1 answer
Mysql select for update ejemplo
SQL
0 vote139 views1 answer
Mysql date format unix timestamp
SQL