Consulta SQL

Article View: chile.comp.programacion

Article #3570

Back to chile.comp.programacion Previous Next

#3570

From: Alvaro G?lvez
Date: Wed, 29 Dec 2004 16:16

16 lines
1051 bytes

una consulta de sql... si tengo una tabla con los siguientes datos:

id     valor
70      1
71      1
72      1
72      2
73      1
74      1
74      2

y quiero saber cuales id tienen valor 1 y 2 (en este caso, debe
retornarme el registro con id 72 y el con id 74) �C�mo hago esa
consulta?

Muchas gracias

Technical Details

Message-ID: <dce856b.0412290816.67ff2d88@posting.google.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,e72fb4d98c32afb4,start
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!not-for-mail
From: bakanon@yahoo.com (Alvaro G?lvez)
Newsgroups: chile.comp.programacion
Subject: Consulta SQL
Date: 29 Dec 2004 08:16:11 -0800
Organization: http://groups.google.com
Lines: 16
Message-ID: <dce856b.0412290816.67ff2d88@posting.google.com>
NNTP-Posting-Host: 200.6.65.123
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1104336971 9578 127.0.0.1 (29 Dec 2004 16:16:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 29 Dec 2004 16:16:11 +0000 (UTC)