Re: How can I select an element that doesn't exists in a table?

From: jose_luis_fdez_diaz <gfiuni2_at_gmail.com>
Date: 13 Nov 2006 06:27:59 -0800
Message-ID: <1163428078.954674.241510@f16g2000cwb.googlegroups.com>

In the table below:

table1

---

1
2
4
5

select 3 from table1 where not exists (select * from table1 where row1!=3)

returns:

3
3
3
3

I only want "one" 3.

How can I get it?

PD: Sorry for my little explanation in the last post.

Regards,
Jose Luis.

Laurenz Albe wrote:
> jose_luis_fdez_diaz <gfiuni2_at_gmail.com> wrote:
> > Idem.
>
> 'Idem' is Latin for 'the same'.
>
> What do you want to tell us?
> Or, more to the point, what is your question?
>
> If it is the question in the subject, please clarify what you want.
>
> Are you looking for 'SELECT 42 FROM dual' ?
>
> Yours,
> Laurenz Albe
Received on Mon Nov 13 2006 - 08:27:59 CST