Lowyat.NET: Latest topics by kelvinli3w

SQL Distinct & Count

kelvinli3w — Mon, 31 May 2010 10:39:13 +0800

I need to do this

CODE

Album_title Music_type Total
xxx Clasic 3
abc Clasic 3
123 Clasic 3
asd Rock 2
fgh Rock 2

Total = the total amount within each music type

but so far i can only do it like this
without the album title it can distinct and count perfectly

CODE

SELECT DISTINCT MUSIC_TYPE.Music_type, COUNT(ALBUM.Music_Type_ID) AS TOTAL
FROM ALBUM, MUSIC_TYPE
WHERE ALBUM.Music_Type_ID = MUSIC_TYPE.Music_Type_ID
GROUP BY MUSIC_TYPE.Music_type;

Music_type Total
Clasic 3
Clasic 3
Clasic 3
Rock 2
Rock 2

but if i include album title, it will look like this

CODE

SELECT ALBUM.Album_title, MUSIC_TYPE.Music_type, COUNT(DISTINCT ALBUM.Music_Type_ID) AS TOTAL
FROM ALBUM, MUSIC_TYPE
WHERE ALBUM.Music_Type_ID = MUSIC_TYPE.Music_Type_ID
GROUP BY ALBUM.Title, MUSIC_TYPE.Music_type;

Album_title Music_type Total
xxx Clasic 1
abc Clasic 1
123 Clasic 1
asd Rock 1
fgh Rock 1

Where did i do wrong? Thanks.

btw i'm using Oracle 10g XE.

any1 know any comic rental shop in subang jaya?

kelvinli3w — Thu, 15 Apr 2010 20:46:32 +0800

does anyone know any comic rental shop around subang jaya?

So far i know that,

Summit 1 already closed.

Taipan got 2 but 1 closed edy and the other 1 will move to another new location soon.

thanks

having problem with win7 64

kelvinli3w — Fri, 05 Mar 2010 18:32:08 +0800

i just applied for the 10gb package + free modem (e1550), i can install the dashboard but after that...it keeps showing Huawei Mobile Connect - USB device driver fails to install.... anybody have a solution for this? i tried to reinstall a few times then manually install, same problem persist =\

my os : Windows 7 64 Ultimate

should i delete HP Recovery Partition?

kelvinli3w — Tue, 15 Sep 2009 22:46:32 +0800

like the title says, should i delete the HP Recovery Partition? I have already create the recovery DVDs, and i need those space for my stuff =3

p/s: i heard that there will be some error message on every boot, after the deletion on the recover partition? is this true?

*The Error Message*
Warning: A partition overlaps your system recovery partition. Press F10 to start system recovery anyway or another key to delete the recovery partition.

Need recommendation on buying notebook

kelvinli3w — Sun, 13 Sep 2009 20:36:03 +0800

Well, long story short, my acer notebook just died a few days ago =\

I need some recommendation on buying a new notebook, my budget is about RM3k, prefer intel + nvidia, which can play new games on low-medium settings and can last for at least 2 years, any brand except Acer.

My choice:

HP Pavilion dv3-2111

any recommendations?

Thank you