Is this a bug or a limitation of the SQL language

From: Salil Kumar Jha <>
Date: Sun, 23 Aug 92 07:40:48 GMT
Message-ID: <>

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')
(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) Received on Sun Aug 23 1992 - 09:40:48 CEST

Original text of this message