Re: Is this a bug or a limitation of the SQL language

In article <1992Aug23.074048.16681_at_prism.poly.edu>, sjha_at_prism.poly.edu (Salil Kumar Jha) writes:
>
> I tried to do this query in Oracle and DB2 and both failed. I know its
> not allowed but why not?
>
> Assume the use of the classic oracle emp table
>
> select * from emp
> where salary between
> (select salary from emp where ename = 'Larry')
> and
> (select salary from emp where ename = 'John')
>
> Isnt this the best way of finding all people whose salaries lie between those
> of Larry and John (without knowing whose is larger)
>
> sjha_at_prism.poly.edu
>
Boy, my first response was really stupid. Too bad I didn't realize it before I sent it. Let me try again:

select * from emp
where salary >= (select min(salary)

                 from emp
                 where ename in ('Larry','John')
and   salary <= (select max(salary)
                 from emp
                 where ename in ('Larry','John')

Now, does that do it? Received on Tue Aug 25 1992 - 21:00:41 CEST