/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

10 votes146 views4 answers
Drop primary key
SQL
0 vote151 views1 answer
One table with another
SQL
0 vote146 views1 answer
Low level operator in dbms
SQL
0 vote211 views1 answer
Do you know sql
SQL
1 vote159 views1 answer
Delete specific row in sql
SQL
0 vote166 views1 answer
How to define a non primary composite key in sql
SQL
0 vote149 views1 answer
How to write if case in select query in select statement
SQL
2 votes156 views1 answer
Sqlite3 show columns name
SQL
0 vote151 views1 answer
Recursive query herarchical data sql server
SQL
1 vote135 views1 answer
Mysql batch insert
SQL