Salam, Coba syntax berikut :
SELECT Merk,Type, COUNT(*)-SUM(Status) AS GOOD, SUM (Status) AS BAD, COUNT(*) AS TOTAL FROM TABEL GROUP BY Merk,Type Semoga membantu. Wassalam, 2008/2/11 b4sm4l inti <[EMAIL PROTECTED]>: > Hai..teman teman aku minta pencerahannya nich. > > ada tabel sebagai berikut : > > IDproduk merek type status > PN001 A SM-X 0 > PN002 A SM-X 1 > PN003 A SM-X 0 > PN004 A SM-Y 0 > PN005 A SM-Y 1 > PN006 A SM-Y 1 > PN007 A SM-Y 1 > > keterangan: > status 0 = Good > status 1 = bad > > Aku ingin query menggunakan SQL server 2005, gimana ya caranya agar > menjadi > seperti ini > > Merek Type Good Bad Total > A SM-X 2 1 3 > A SM-Y 1 3 4 > > salam > > __________________________________________________________ > Never miss a thing. Make Yahoo your home page. > http://www.yahoo.com/r/hs > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
