SQL query to find out Avg Salary location wise ?
Name|Location|Salary
====|========|======
a |Bombay |4000
b |Bombay |5000
c |Delhi |3000
d |Delhi |6000
e |Chennai |700
f |Chennai |9000
Asked
Active
Viewed 31 times
-2
osiris_v6
- 452
- 2
- 9
-
1Hint: `GROUP BY`. – Gordon Linoff Aug 01 '19 at 10:39
-
Possible duplicate of [MySQL order by before group by](https://stackoverflow.com/questions/14770671/mysql-order-by-before-group-by) – Sami Ahmed Siddiqui Aug 01 '19 at 10:57
1 Answers
0
use average and group by to get your result.
select location , avg(salary) as Average from table group by location
You may find this link for more info link.
DarkRob
- 3,843
- 1
- 10
- 27
-
. . . `DISTINCT` is not very helpful when using `GROUP by` clause. – Yogesh Sharma Aug 01 '19 at 10:46