/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

2 votes185 views5 answers
SQL trigger
SQL
1 vote272 views4 answers
Alter schema sql
SQL
9 votes176 views3 answers
Mysql get last id
SQL
1 vote230 views1 answer
Sqlalchemy on delete set null
SQL
0 vote246 views1 answer
Oracle job session
SQL
0 vote176 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote139 views1 answer
Delete all rows from table sqlite
SQL
0 vote196 views1 answer
Google cloud sql postgres url example
SQL
0 vote222 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote176 views1 answer
Run mssql server terminal
SQL