Re: SQL

From: krutohlav (krutohlav@host.sk)
Date: 08. 12. 2001, 13:04 CET

Previous message: Jiri Cvrk: "jak precist soubory z MS publisheru"
In reply to: Ladislav Fabian: "SQL"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Nazdar,
Thursday, December 06, 2001, si napisal:

> SELECT
>  cislo_objednavky, suma 
> FROM 
>  objednavky 
> WHERE
>  uzivatel LIKE "$uzivatel"
> GROUP BY
>  cislo objednavky

> Skusal som SELECT cislo_objednavky, SUM(suma), ale
> akosi to nefunguje...

tak skus SELECT cislo_objednavky, SUM(suma) as prachy FROM ...
potom celkovu sumu vyfetchujes v prachy. Musi to fungovat.

S pozdravom,
 krutohlav

Previous message: Jiri Cvrk: "jak precist soubory z MS publisheru"
In reply to: Ladislav Fabian: "SQL"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 08. 12. 2001, 17:24 CET