473,480 Members | 1,855 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Abfrage definieren: [Katze, Katze, Hund,Hund, Hund, Vogel,....] --> [Katze, Hund, Vogel]

Wie kann ich eine Abfrage erzeugen,die unten aufgeführtes Abfrageergebnis erzeugt?

Tabelle A:
1. Hund
2. Hund
3. Hund
4. Katze
5. Katze
6. Vogel

das Abfrageergebnis soll ergeben:
1. Hund
2. Katze
3. Vogel

Gruss
simpson
Nov 13 '05 #1
1 1965
On 2 Aug 2004 05:54:56 -0700, ac****************@spamgourmet.com
(simpson) wrote:

Check out the Distinct keyword.
-Tom.
Wie kann ich eine Abfrage erzeugen,die unten aufgeführtes Abfrageergebnis erzeugt?

Tabelle A:
1. Hund
2. Hund
3. Hund
4. Katze
5. Katze
6. Vogel

das Abfrageergebnis soll ergeben:
1. Hund
2. Katze
3. Vogel

Gruss
simpson


Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1558
by: Suzanne Vogel | last post by:
** Is there a way (C++ syntax) to specify that a pointer should refer to an object that derives from *two* specific classes? eg, Suppose I have two classes, 'A' and 'B', and I want to specify...
1
6793
by: Christian Schmidbauer | last post by:
Hello! I prepare my XML document like this way: ------------------------------------------------------- PrintWriter writer; Document domDocument; Element domElement; // Root tag
11
13649
by: Les Paul | last post by:
I'm trying to design an HTML page that can edit itself. In essence, it's just like a Wiki page, but my own very simple version. It's a page full of plain old HTML content, and then at the bottom,...
5
2317
by: Luke Vogel | last post by:
Hi all, Probably a really basic question, but I cant find an answer ... I have an xml file of books something like: <product> <isbn>0-735-61374-5</isbn> <title>Microsoft Visual Basic Step By...
1
4806
by: Ingo Kollesch | last post by:
Moin, gibt es eine DB2 Funktion/Abfrage oder View um die User/User Group abzufragen? Ich möchte in meiner Anwendung abfragen ob der eingeloggte User bestimmte Rechte auf der Datenbank hat. Kann...
4
3335
by: Fresh80 | last post by:
Hallo Newsgroup. Ich möchte eine Abfrage die ich im Access2003 erstellt habe auch in der Befehlszentrale vom DB2 erstellen. Doch die Funktion "first" kennt DB2 nicht. Anbei der SQL Code vom...
0
2043
by: Hans-Peter Reichert | last post by:
Hallo Power-User, könnt Ihr mir bitte Eure Hilfe bei folgendem Problem geben: In einem Formular habe ich jeweils 2 x 12 Datenfelder für die Monate Januar bis Dezember angelegt (jan1bis dez1...
2
2056
by: Tom Vogel | last post by:
I'd like to use the XML Documentation Tags to comment my C# code. But many of the tags do not have any effect when I execute the "Build Comment Web Pages" menu. For example, the <list> tag gets...
1
3997
by: Patrick Roos | last post by:
Hallo zusammen, Immer wenn ich per Select Statement ( SELECT ObjectId FROM tblArtikel WHERE ArtNr = paramArtNr ) (paramArtNr ist ein String Parameter) über einen TableAdapter absetze bekomme ich...
0
7048
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6741
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
6956
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
4783
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4485
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2997
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
2986
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
563
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
183
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.