Get rows with Group BY in MySQL
NVO
Let's assume I have the following table:
I need the numbers from the column 'Shares' ordered by 'Company'.
So, Example:
ABC, INC: 88624 + 5588 + 442214 + 11233
DEF Corp.: 4556 + 444863 + 44601
Is there a way to do this using MySQL? Or maybe PHP?
John
Aggregate function is the best method:
SELECT SUM(shares), company
FROM table_name
GROUP BY company
The SUM() will do the necessary calculation of the same company name. The GROUP BY will show them by company.
If you want specific companies not all (let's say 2 companies only): You can add WHERE Company = "ABC inc" OR "DEF Corp"
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
Get rows with Group BY in MySQL
- 2
Get Rows By Group MySQL Java
- 3
mysql query with GROUP BY not get all rows
- 4
How to get the average and the last data from a group of rows in a table in MySQL
- 5
how to get top 300 rows for each group in mysql?
- 6
MySQL Limit Rows / Group By
- 7
Creating view in mysql for a group of rows
- 8
Temporarily Number Rows to Group by in MYSQL
- 9
MySQL GROUP BY and remove null rows
- 10
Group and display MYSQL rows by day?
- 11
mysql group by return all the rows
- 12
MySQL GROUP BY and remove null rows
- 13
Grouping rows in mysql in clausule group by
- 14
MySql Limit rows but without truncating group of rows
- 15
Select rows with GROUP BY excluding GROUP with flag ( MySQL )
- 16
get consecutive rows mysql
- 17
MySQL query to get the max, min with GROUP BY and multiple table joins in separate rows
- 18
MySQL - Get all rows from left table per group on right table
- 19
MySQL Query: GROUP BY without loosing rows in result
- 20
mysql select the first n rows per group
- 21
Multiple group by and count the grouped rows using mysql
- 22
MySQL group multiple rows based on DISTINCT value
- 23
Mysql select min in group of rows where userid=?
- 24
Selecting N rows from each group in MYSQL
- 25
How to group rows in mysql to be as chunks with a specific size
- 26
Mysql GROUP_CONCAT of first n rows
- 27
MySQL GROUP BY: How to return multiple rows?
- 28
MySQL sum last X rows per group
- 29
MYSQL calculate time between rows and group as sessions
Comments