Help with SQL statement

Article View: borland.public.cppbuilder.database.ado

Article #850

Back to borland.public.cppbuilder.database.ado Previous Next

#850

From: Vladimir Stefanovic
Date: Mon, 20 Jun 2005 19:20

36 lines
1511 bytes

I have a single table with this imaginary format:

ID     TEXT
------------
2      AAAA
5      BBBBB
4      CCCC
3      AAAA
1      BBBBB

ID is uniq
TEXT is not unique

I want to extract into NEW Table

   AAAA
   BBBB
   CCCC

somehow like

      "INSERT INTO TblTmp (Text)\n"
      "SELECT Text\n"
      "FROM TblSource\n"
      "GROUP BY Text";

...but I want them ALSO to be sorted by ID, and I doesn't
know how to involve ORDER into this...





-- 
Best regards,
Vladimir Stefanovic

Technical Details

Message-ID: <42b71709@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!novia!feed5.newsreader.com!newsreader.com!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,d883a75625ee119f,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Vladimir Stefanovic" <antivari@po.sbb.co.yu>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Help with SQL statement
Date: Mon, 20 Jun 2005 21:20:48 +0200
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.117.212.65
Message-ID: <42b71709@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1119295241 82.117.212.65 (20 Jun 2005 12:20:41 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!novia!feed5.newsreader.com!newsreader.com!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail