Using MAX( ) function in SQL.

Hi

I am having trouble with a question I have been set for uni.

my table is as follows;

part(partno, description, colour, cost);

I need to use the MAX function, to select the row with the maximum cost, and the other 3 fields.

SELECT MAX(cost), colour, partno
FROM part;

Why can`t I do this? what is wrong with the syntax, or am I missing something maybe.

I have also tried

SELECT MAX(cost), MAX(colour), MAX(partno)

but that only selects the max of each individual field.

Can anyone help? Received on Sun Nov 26 2000 - 08:15:52 CST