Re: sm� spurning -- Gagnasafnsfr��i, umr��ur

[ Show ]

Support VoyForums

[ Shrink ]

VoyForums Announcement: Programming and providing support for this service has been a labor of love since 1997. We are one of the few services online who values our users' privacy, and have never sold your information. We have even fought hard to defend your privacy in legal cases; however, we've done it with almost no financial support -- paying out of pocket to continue providing the service. Due to the issues imposed on us by advertisers, we also stopped hosting most ads on the forums many years ago. We hope you appreciate our efforts.

Show your support by donating any amount. (Note: We are still technically a for-profit company, so your contribution is not tax-deductible.) PayPal Acct: Feedback:

Donate to VoyForums (PayPal):

[ Login ] [ Contact Forum Admin ] [ Main index ] [ Post a new message ] [ Search | Check update time | Archives: 1, [2] ]

Subject: Re: sm� spurning

Author:
Hj�lmt�r

[ Next Thread | Previous Thread | Next Message | Previous Message ]

Date Posted: 15:20:15 01/Oct/2007
In reply to: 's message, "sm� spurning" on 01:55:38 01/Oct/2007

>Ef vi� h�fum t.d. eftirfarandi ni�urst��u �r t�flu sem
>er �tkoma �r fyrirspurn
>
>epli
>epli
>banani
>appels�na
>
>er h�gt a� finna a� �a� er epli sem kemur oftast �t?

�� vilt �� finna max(count(*)), en �a� er ekki h�gt a� hafa hrei�ra�a samsafnsvirkja. �a� er s�nid�mi � b�kinni,
Q37 � bls. 161, sem s�nir eitthva� svipa� (nema min(avg(.))). Lausnin �ar (efst � bls. 162) virkar reyndar ekki
� PostgreSQL, �ar sem ekki er h�gt a� nota t�flunafni� Temp � where-hlutanum. �a� er h�gt a� leysa �a� me� �v� a�
endurtaka select-skipunina. Til d�mis:

select temp.rating, temp.avgage
from (select s.rating, avg(s.age) as avgage
from sailors s
group by s.rating) as temp
where temp.avgage = (select min(temp2.avgage2) from (select s2.rating, avg(s2.age) as avgage2
from sailors s2
group by s2.rating) as temp2)

[ Next Thread | Previous Thread | Next Message | Previous Message ]