/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 vote112 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
2 votes67 views1 answer
Foreign key example in dbms
SQL
0 vote96 views2 answers
How to start postgresql laravel
SQL
0 vote100 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote118 views1 answer
Get a list of tables and the primary key
SQL
11 votes109 views1 answer
Mysql text type max length
SQL
12 votes111 views1 answer
Script to add new column in table sql
SQL
3 votes62 views4 answers
Show columns from table
SQL
4 votes103 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote113 views2 answers
Postgresql get long running queries
SQL