/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 vote115 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote112 views1 answer
Order by ip address sql
SQL
0 vote118 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
1 vote128 views1 answer
Mamp mysql path mac
SQL
0 vote123 views1 answer
Ajax error exception handeling
SQL
7 votes113 views2 answers
Sql empty table
SQL
0 vote111 views2 answers
Mysql password error create datbase
SQL
10 votes147 views4 answers
Join multiple tables in sql
SQL
0 vote109 views1 answer
Power query case when
SQL
0 vote84 views1 answer
Sql query with date
SQL