Re: SQL question

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 10 Feb 2000 12:14:46 +0100
Message-ID: <87u6jc$2uhf$1@news4.isdnet.net>

If you mean which description is equal to TOR for the min value:

select distinct description1, description2, number from table
where number = ( SELECT MIN(number)

                 FROM    table
                 WHERE  description1 = 'TOR' or description2 = 'TOR' )

--
Have a nice day
Michel

Curt Ingram <cingramb_at_bigfoot.com> a écrit dans le message : Vxvo4.12743$Mk2.520212_at_newsread2.prod.itd.earthlink.net...
> given the following query,
>
> SELECT MIN(number)
> FROM table
> WHERE description1 = 'TOR' or description2 = 'TOR';
>
> is there a clean way to know which side of the 'or' statement was satisfied
> ?
>
> Thanks,
> Curt
>
>
>
Received on Thu Feb 10 2000 - 05:14:46 CST