Re: Consulta SQL

Article View: chile.comp.programacion

Article #3461

Back to chile.comp.programacion Previous Next

#3461

From: Michael
Date: Fri, 31 Dec 2004 16:56

32 lines
1843 bytes

Select id from nombre_de_tu_Tabla where valor = 2

Si quieres pasar el valor a traves de un parametor o una variable
Select id from nombre_de_tu_tabla where valor = '" & variable & "'

"Claudio Madrid" <claudio_madrid72@hotmail.com> escribi� en el mensaje
news:41d413b9$1_1@nova.entelchile.net...
> 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: <cr40dd$j09$1@news1.nivel5.cl>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!not-for-mail

References: <dce856b.0412290816.67ff2d88@posting.google.com> <41d413b9$1_1@nova.entelchile.net>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,e72fb4d98c32afb4
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!not-for-mail
From: "Michael" <michaelg@NO-MAS-SPAM-NI-CADENAS.vtr.net>
Newsgroups: chile.comp.programacion
Subject: Re: Consulta SQL
Date: Fri, 31 Dec 2004 13:56:38 -0300
Organization: Varios
Lines: 34
Message-ID: <cr40dd$j09$1@news1.nivel5.cl>
References: <dce856b.0412290816.67ff2d88@posting.google.com> <41d413b9$1_1@nova.entelchile.net>
NNTP-Posting-Host: cm600-vina2-67-59.cm.vtr.net
X-Trace: news1.nivel5.cl 1104512237 19465 200.104.67.59 (31 Dec 2004 16:57:17 GMT)
X-Complaints-To: news@news1.nivel5.cl
NNTP-Posting-Date: Fri, 31 Dec 2004 16:57:17 +0000 (UTC)
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

Reply to Parent Message