Re: SQL Query question

From: Bob McConnell <bobmc_at_cyberramp.net>
Date: Wed, 03 Jun 1998 21:43:31 GMT
Message-ID: <3575c1ca.433899374@news.internetmci.com>

Actually I'm trying to retrieve the complete records which contain several other fields. So what I'm trying to accomplish is select MAX(taskno),id, otherfield1,otherfield2,etc.

How do I get by "NOT A SINGLE GROUP GROUP FUNCTION" error for the other fields I need?

BYOn Tue, 02 Jun 1998 07:45:17 -0500, kiel <kiel_at_webpre.com> wrote:

>Bob McConnell wrote:
>>
>> Need help with:
>>
>> I have a table with columns ID and TASKNO which
>> looks like:
>>
>> TASKNO ID field3 field4 field5
>> 1 JOB1
>> 2 JOB1
>> 3 JOB1
>> 1 JOB2
>> 2 JOB2
>> 1 JOB3
>> 2 JOB3
>>
>> I need to be able to select one of each ID
>> based on the highest TASKNO
>>
>> Resulting in
>> TASKNO ID field3 field4 field5
>> 3 JOB1 data data data
>> 2 JOB2 data data data
>> 2 JOB3 data data data
>>
>> Thanks,
>> Bob
>
>do you mean
>
>select max(taskno), id
> from table
> group by id
>
>?
>
>Christian
Received on Wed Jun 03 1998 - 16:43:31 CDT