/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 vote294 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote292 views1 answer
Mysql select all where count more than"
SQL
0 vote293 views1 answer
Google cloud sql postgres url example
SQL
2 votes322 views1 answer
Postgresql update sequence next value
SQL
0 vote341 views1 answer
Creating sqeuence in oracle database
SQL
2 votes314 views4 answers
Sql query interview questions
SQL
0 vote277 views1 answer
How to check replication lag in mySQL
SQL
0 vote322 views1 answer
Search from comma separated values in sql server
SQL
3 votes311 views2 answers
Postgres show table schema
SQL
0 vote318 views1 answer
How to select all fieldsin a soql query
SQL