This is one of the aggregate functions, not unlike MIN, in T-SQL. Below, given all the Number values for a particular Name, this will place the highest in the second column.
SELECT Name, Max(Number) FROM Nonsense
GROUP BY Name
This is one of the aggregate functions, not unlike MIN, in T-SQL. Below, given all the Number values for a particular Name, this will place the highest in the second column.
SELECT Name, Max(Number) FROM Nonsense
GROUP BY Name
No comments:
Post a Comment