Registracija

SQL upit - podupit

Odgovori Nova tema

1 odgovor
2.674 pregleda

SQL upit - podupit 27.08.2007. u 13:26 · pre 233 meseca #1

Imam tabelu:

col1 col2 col3 col4 col5
2007 12 88 47 A
2007 48 77 33 B
2007 48 66 87 A
2007 44 45 96 B

Kako da od ova dva upita napravim jedan? Da li je to moguce pomocu podupita?

SELECT col1, SUM(col2), SUN(col3)
FROM dbo.proba
GROUP BY col1, col5
HAVING (col1 = '2007') AND (col5 = 'B')

SELECT col1, SUM(col4)
FROM dbo.proba
GROUP BY col1
HAVING (col1 = '2007')

Stvar je u tome sto se u koloni 2 i 3 sumiraju samo pojedini redovi u zavisnosti od uslova u koloni 5, a u koloni 4 se sumiraju svi redovi.

Hvala, pozdrav.

Re: SQL upit - podupit 27.08.2007. u 13:41 · pre 233 meseca #2

Code:

SELECT x.col1, x.col2, x.col3, y.col4
  FROM (SELECT col1, SUM(col2) AS col2, SUM(col3) AS col3
          FROM dbo.proba
         WHERE col5 = 'B'
         GROUP BY col1
       ) AS x
       INNER JOIN
       (SELECT col1, SUM(col4) AS col4
          FROM dbo.proba
         GROUP BY col1
       ) AS y
         ON x.col1 = y.col1
WHERE col1 = '2007'
ORDER BY x.col1;

Potpis

"The best code is no code at all."
- Zidar (ES član)
"Biggest obstacle to learning
SQL is unlearning procedural
programming." - Joe
Celko
"Minimize code, maximize data."
- A. Neil Pappalardo

Prijavite se da biste odgovorili u ovoj temi.Prijava Registracija

Forum kao aplikacija na telefonu

Srodne teme