Intrebari

Re: select mai ciudat.

ggciubuc — Fri, 20 Oct 2006 19:10:40 GMT

Viteza? Indecsii?

Re: select mai ciudat.

sorinh — Fri, 20 Oct 2006 11:37:29 GMT

Am rezolvat facind un inner join de genul : select distinct r1.r, r2.r, r3.r, item4 from tabela inner join (select count( * ) r, item4 from tabela where conditie group by item4) r1 on tabela.item4 = r1.item4 .... inner join (...) r2 on tabela.item4 = r2.item4

Re: select mai ciudat.

ggciubuc — Thu, 19 Oct 2006 10:29:10 GMT

Realizati ceva similar cu

select Year,

sum (CASE Quarter WHEN 1 THEN Amount ELSE 0 END) as Trim1,

sum (CASE Quarter WHEN 2 THEN Amount ELSE 0 END) as Trim2,

sum (CASE Quarter WHEN 3 THEN Amount ELSE 0 END) as Trim3,

sum (CASE Quarter WHEN 4 THEN Amount ELSE 0 END) as Trim4

from Northwind.dbo.Tabel

Group by YEAR

face sumarizare pe trimestre.

Dvs faceti numarare, in conditiile in care item1 are niste valori discrete de un nr. redus.

select mai ciudat.

sorinh — Thu, 19 Oct 2006 10:10:48 GMT

Am nevoie de un select mai ciudat (sql server 2000) care ar fi ceva de genul : select (select count(item1) from tabela where cond1 as rezultat1), (select count(item2) from tabela where cond2 as rezultat2), (select count(item3) from tabela where cond3 as rezultat3), item4 from tabela group by item4 imi intoarce rezultatele multipilcate. E posibil sa construiesc un astfel de select ? Pe mine ma inteereseaza o sumarizare a rezultatelor pentru fiecare valoare a lui item4.