Re: Using MAX( ) function in SQL.

Think about the question as:

    select all the details from the row where the cost is

        (the maximum cost of all the rows in the table.)

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Jack Torrence wrote in message ...


>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?