Re: Consulta SQL

Article View: chile.comp.programacion

Article #3460

Back to chile.comp.programacion Previous Next

#3460

From: Claudio Madrid
Date: Thu, 30 Dec 2004 10:41

23 lines
1420 bytes

select id, valor from tabla where valor in (1,2)

saludos


"Alvaro G?lvez" <bakanon@yahoo.com> escribi� en el mensaje
news:dce856b.0412290816.67ff2d88@posting.google.com...
> 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: <41d413b9$1_1@nova.entelchile.net>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!nova.entelchile.net

References: <dce856b.0412290816.67ff2d88@posting.google.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,e72fb4d98c32afb4
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
From: "Claudio Madrid" <claudio_madrid72@hotmail.com>
Newsgroups: chile.comp.programacion
References: <dce856b.0412290816.67ff2d88@posting.google.com>
Subject: Re: Consulta SQL
Date: Thu, 30 Dec 2004 11:41:53 +0100
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 164.77.238.114
X-Original-NNTP-Posting-Host: 164.77.238.114
Message-ID: <41d413b9$1_1@nova.entelchile.net>
X-Trace: nova.entelchile.net 1104417721 164.77.238.114 (30 Dec 2004 11:42:01 -0300)
X-Original-NNTP-Posting-Host: 164.77.238.114
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!nova.entelchile.net

Reply to Parent Message