[DUG] sql - GROUP
Pieter De Wit
pieter at insync.za.net
Sun Nov 10 20:16:38 NZDT 2013
Hi,
Try:
select * from table group by itemID order by name,Number DESC
Cheers,
Pieter
On 10/11/2013 20:09, John C wrote:
>
> Hi all
>
> Can anybody help me with the following query?
>
> I have a table like:
>
> *_ItemID Name Number_*
>
> 234 Washer 100
>
> 234 Washer 120
>
> 234 Washer 105
>
> 500 Nut 520
>
> 500 Nut 502
>
> 500 Nut 501
>
> What I would like to see is a for each ItemID the highest Number
> sorted by Name.
>
> My sql is like:
>
> *SELECT **
>
> *FROM Table*
>
> *GROUP BY ItemID*
>
> *ORDER BY Name, Number*
>
> What returns is:
>
> *_ItemID Name Number_*
>
> 234 Washer 105
>
> 500 Nut 501
>
> It seems to return the last record for each item. How can I get the
> highest number for each Item?
>
> Thanks a lot for any help.
>
> John C
>
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at listserver.123.net.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20131110/db4fe8d8/attachment-0001.html
More information about the Delphi
mailing list