Re: SQL Help!

Kathy Holley wrote:
>
> Is there a simple way of doing this:
> My table has 2 column: Language, desc
> I need to select desc where Language = 2, if no rows are returned, then I
> need to select desc where Language = 1;
> (Language =1 is the default and will always be there)
> I wrote one select statement to do it, but it seems a bit complicated, I
> use 1 sub-select with 'EXIST' and one union.
> I am sure there must be a better way to do it without having to check for
> nulls and sending a second query.
>
> Thanks in advance for your help!

Hi,

Try this:

select desc from tab where lang=(select max(lang) from tab);

                Peter. Received on Thu Jul 25 1996 - 00:00:00 CEST