/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 vote149 views1 answer
Sql cnvert bit to nvarchar
SQL
2 votes137 views1 answer
Oracle generated column
SQL
4 votes143 views2 answers
Postgre sql create table
SQL
0 vote158 views1 answer
Snowflake drop column
SQL
3 votes149 views5 answers
Sql select
SQL
2 votes137 views2 answers
Sql first character
SQL
0 vote142 views1 answer
Mysql get longest string in column
SQL
0 vote163 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote137 views1 answer
Create synonym for dblink in oracle
SQL
0 vote142 views1 answer
Get last three characters in mysql column
SQL