[tritiy]

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?