Re: Consulta SQL

Article View: chile.comp.programacion

Article #3571

Back to chile.comp.programacion Previous Next

#3571

From: Leonardo Herrera
Date: Wed, 29 Dec 2004 16:54

23 lines
1329 bytes

Alvaro G?lvez wrote:
> 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

Ehhh, �select * from tabla where valor = 2?

-- 
Leonardo Herrera
http://pipes.epublish.cl

Technical Details

Message-ID: <33g5lkF3vljjpU2@individual.net>

Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail

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
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Leonardo Herrera <leus@epublish.cl>
Newsgroups: chile.comp.programacion
Subject: Re: Consulta SQL
Date: Wed, 29 Dec 2004 13:54:02 -0300
Lines: 23
Message-ID: <33g5lkF3vljjpU2@individual.net>
References: <dce856b.0412290816.67ff2d88@posting.google.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: individual.net dOcpylG+JDJykPCk2spxtwI1rdhXTT7ggVUe2zd5+nSbiJbRP6
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8a4) Gecko/20040927
X-Accept-Language: en-us, en
In-Reply-To: <dce856b.0412290816.67ff2d88@posting.google.com>

Reply to Parent Message