/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 votes278 views2 answers
Mysql show table column comments sql
SQL
0 vote265 views1 answer
How to change the field size of an existing column
SQL
2 votes291 views1 answer
Sqlite3 show columns name
SQL
36 votes283 views3 answers
Finding duplicate column values in table with sql
SQL
9 votes310 views3 answers
Where clause sql
SQL
-1 vote251 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote269 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote270 views2 answers
Sql select only first occurrence
SQL
0 vote270 views1 answer
Oracle job class
SQL
0 vote301 views1 answer
Databricks install odbc driver connect to sql server
SQL