Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
----- Original Message ----- From: Marta Pérez RomeroTo: Oliveiros d'Azevedo CristinaCc: pgsql-novice@postgresql.orgSent: Friday, May 04, 2012 12:19 PMSubject: Re: [NOVICE] Query to get the min of the totalThe below works!!! I am investigating if it covers everything, but looks good! Thanks a mill!!!!On 4 May 2012 12:12, Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt> wrote:SELECT *FROM(SELECT petname,SUM(quantity) as totalFROM pets a NATURAL JOIN sales bGROUP BY petname) xNATURAL JOIN(SELECT MIN(total) as totalFROM(SELECT petname,SUM(quantity) as totalFROM pets a NATURAL JOIN sales bGROUP BY petname)y)z
SELECT *FROM(SELECT petname,SUM(quantity) as totalFROM pets a NATURAL JOIN sales bGROUP BY petname) xNATURAL JOIN(SELECT MIN(total) as totalFROM(SELECT petname,SUM(quantity) as totalFROM pets a NATURAL JOIN sales bGROUP BY petname)y)z
В списке pgsql-novice по дате отправления: