Re: SQL Query question

Read about "group by".

Yigal

Bob McConnell wrote:

> 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 Thu Jun 04 1998 - 08:48:47 CDT