On Wed, 23 Jun 2004, cristi wrote:
> si ale caror date continute de acesta sunt:
>
> 22021CC 1044 637 S5G8 407 5
> 22021CC 1044 637 S5G8 409 47
> 22021CD 1044 637 S5G8 410 24
> 22022BB 1044 637 S5G8 409 10
>
> Vreau o instructiune sql a carui rezultat sa fie de forma:
>
> 22021CC 1044 637 S5G8 407 5
> 22021CC 1044 637 S5G8 409 57
> 22021CD 1044 637 S5G8 410 24
SELECT co1, n1, l1, l1, SUM(ore)
FROM table
GROUP BY co1, n1, l1, m1
ORDER BY co1 DESC;
??
--
Any views or opinions presented within this e-mail are solely those of
the author and do not necessarily represent those of any company, unless
otherwise expressly stated.
---
Detalii despre listele noastre de mail: http://www.lug.ro/
