Article View: dk.edb.database
Article #15347Re: [MS SQL 7] GROUP BY - p� bit-kolonne
From: Jesper Stocholm
Date: Wed, 23 May 2001 13:58
Date: Wed, 23 May 2001 13:58
19 lines
1417 bytes
1417 bytes
spam@stocholm.dk (Jesper Stocholm) wrote in <Xns90AA9E3C31AFDspamstocholmdk@153.80.109.11>: >SELECT firstname, lastname, CAST(ignorant as smallint) AS ignorant >FROM table >GROUP BY firstname, lastname, male det skulle selvf�lgelig v�re denne SELECT: SELECT firstname, lastname, CAST(ignorant as smallint) AS ignorant FROM table GROUP BY firstname, lastname, ignorant :o) -- Jesper Stocholm Systems Analyst Copenhagen, Denmark
Technical Details
Message-ID:
<Xns90AAA28439E77spamstocholmdk@153.80.109.11>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!news-out.visi.com!hermes.visi.com!news.maxwell.syr.edu!newsfeed.cwix.com!pullfeed!rpc1283.DaytonOH.NCR.COMReferences:
<Xns90AA9E3C31AFDspamstocholmdk@153.80.109.11>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fcdf9,ffbf9e0f89c9c28f X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-05-23 07:00:05 PST Newsgroups: dk.edb.database Subject: Re: [MS SQL 7] GROUP BY - p� bit-kolonne From: spam@stocholm.dk (Jesper Stocholm) References: <Xns90AA9E3C31AFDspamstocholmdk@153.80.109.11> Organization: NCR SE-Copenhagen Message-ID: <Xns90AAA28439E77spamstocholmdk@153.80.109.11> User-Agent: Xnews/4.01.30 X-Original-NNTP-Posting-Host: b302.copenhagen.ncr.com Date: 23 May 2001 09:58:37 -0400 X-Original-Trace: 23 May 2001 09:58:37 -0400, b302.copenhagen.ncr.com Lines: 19 NNTP-Posting-Host: ncrnews.daytonoh.ncr.com X-Trace: rpc1283.DaytonOH.NCR.COM 990626321 ncrnews.daytonoh.ncr.com (23 May 2001 09:58:41 -0400) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!news-out.visi.com!hermes.visi.com!news.maxwell.syr.edu!newsfeed.cwix.com!pullfeed!rpc1283.DaytonOH.NCR.COM