大佬们请问这个语句为什么没有报错呀

[qq_51088701]

--drop TABLE if exists TABLE Person;

CREATE TABLE Person (
    Area varchar(50),
    Salary INT,
    Name varchar(50),
    Month INT
);

INSERT INTO Person VALUES ('华南', 2200, '张三', 3);
INSERT INTO Person VALUES ('华北', 2300, '李四', 5);
INSERT INTO Person VALUES ('华南', 2500, '王五', 7);
INSERT INTO Person VALUES ('华西', 2600, '赵六', 1);
INSERT INTO Person VALUES ('华东', 3200, '李毅', 2);
INSERT INTO Person VALUES ('华东', 3300, '色色', 3);
INSERT INTO Person VALUES ('华北', 3400, '李四', 3);
INSERT INTO Person VALUES ('华南', 2250, '张三', 8);
INSERT INTO Person VALUES ('华东', 2800, '李毅', 9);
INSERT INTO Person VALUES ('华西', 3054, '赵六', 12);
INSERT INTO Person VALUES ('华北', 3300, '威威', 11);

--SELECT * FROM Person;
select Area,max(Salary) as Salary,Name
from (
select Area,avg(Salary) as Salary,Name from Person group by Area,Name) as a
group by Area

[Bug真菌]

@qq_51088701 mysql8的linux会报错

[qq_51088701]

grop by 后没有的字段不是不能出现在select 后面吗 为什么我写的这个语句没有报错呀。。

[猫狸嘎]

有没有可能你这用的不是sqlserver，因为放我这sqlserver执行是报错的。如果不可能，那一定是你执行的sql不完整

[吉普赛的歌]

你用的是 mysql 吗？

[二月十六]

CREATE TABLE Person (
    Area varchar(50),
    Salary INT,
    Name varchar(50),
    Month INT
);

INSERT INTO Person VALUES ('华南', 2200, '张三', 3);
INSERT INTO Person VALUES ('华北', 2300, '李四', 5);
INSERT INTO Person VALUES ('华南', 2500, '王五', 7);
INSERT INTO Person VALUES ('华西', 2600, '赵六', 1);
INSERT INTO Person VALUES ('华东', 3200, '李毅', 2);
INSERT INTO Person VALUES ('华东', 3300, '色色', 3);
INSERT INTO Person VALUES ('华北', 3400, '李四', 3);
INSERT INTO Person VALUES ('华南', 2250, '张三', 8);
INSERT INTO Person VALUES ('华东', 2800, '李毅', 9);
INSERT INTO Person VALUES ('华西', 3054, '赵六', 12);
INSERT INTO Person VALUES ('华北', 3300, '威威', 11);

--SELECT * FROM Person;
select Area,max(Salary) as Salary,Name
from (
select Area,avg(Salary) as Salary,Name from Person group by Area,Name)  a
group by Area,Name