SQL Statement

Article View: borland.public.interbase.sql

Article #11296

Back to borland.public.interbase.sql Previous Next

#11296

From: Bambang P.
Date: Wed, 27 Nov 2002 08:55

30 lines
1345 bytes

Hi!
I have table like below:

kd        jns
------------
A         001
A         001
A         002
B         001
B         002
B         002
C         001
D         002

and I want to group by kd  and the result like this:

kd        001    002
-------------------
A          2        1
B          1        2
C          1        -
D          -        1
-------------------

Can anyone help me with this query?

--

Thanks
Bambang P.

Technical Details

Message-ID: <3de4886d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,35312f00878810db,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-27 01:10:20 PST
From: "Bambang P." <benkbenk@bozz.com>
Newsgroups: borland.public.interbase.sql
Subject: SQL Statement
Date: Wed, 27 Nov 2002 15:55:38 +0700
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 202.155.143.47
Message-ID: <3de4886d@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038387309 202.155.143.47 (27 Nov 2002 00:55:09 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail