/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

8 votes337 views1 answer
Insert a select statement into a table
SQL
1 vote377 views1 answer
Pl sql create table from another table
SQL
0 vote375 views2 answers
Replace null with 0 in sql
SQL
4 votes334 views1 answer
Select first and last row sql
SQL
1 vote337 views2 answers
Replace text in sql
SQL
1 vote343 views1 answer
Oracle list data files
SQL
5 votes362 views1 answer
Mysql created at yesterdau
SQL
4 votes335 views1 answer
Check database name postgresql
SQL
0 vote405 views1 answer
Find and replace query in wordpress\
SQL
0 vote351 views1 answer
Sql server get date of previous sunday
SQL