Number 6 was really surprising: SELECT max(salary), first_name, last_name FROM employee; This returns one row! AFAIK all other databases would return one row

Number 6 was really surprising: SELECT max(salary), first_name, last_name FROM employee; This returns one row! AFAIK all other databases would return one row per record in the table where first_name, last_name would be from the row while max(salary) would be the value from the row with max salary. Is this SQL ANSI compatible?