home *** CD-ROM | disk | FTP | other *** search
- Xref: sparky comp.databases:6330 comp.databases.theory:393 comp.databases.oracle:1378
- Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
- Path: sparky!uunet!decwrl!deccrl!news.crl.dec.com!rdg.dec.com!uvo.dec.com!tplab.enet.dec.com!sobczak
- From: sobczak@tplab.enet.dec.com (Piotr Sobczak)
- Subject: Re: Is this a bug or a limitation of the SQL language
- Message-ID: <1992Aug26.090643.1318@decuk.uvo.dec.com>
- Lines: 33
- Sender: usenet@decuk.uvo.dec.com (News Account)
- Reply-To: sobczak@tplab.enet.dec.com (Piotr Sobczak)
- Organization: Digital Equipment Corporation
- References: <1992Aug23.074048.16681@prism.poly.edu>
- Date: Wed, 26 Aug 1992 09:06:43 GMT
-
-
- In article <1992Aug23.074048.16681@prism.poly.edu>, sjha@prism.poly.edu (Salil Kumar Jha) writes:
- |> Xref: uvo.dec.com comp.databases:19031 comp.databases.theory:378 comp.databases.oracle:1346
- |> Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
- |> Path: uvo.dec.com!rdg.dec.com!news.crl.dec.com!deccrl!caen!destroyer!gatech!news.ans.net!cmcl2!prism.poly.edu!sjha
- |> From: sjha@prism.poly.edu (Salil Kumar Jha)
- |> Subject: Is this a bug or a limitation of the SQL language
- |> Message-ID: <1992Aug23.074048.16681@prism.poly.edu>
- |> Organization: Polytechnic University, New York
- |> Date: Sun, 23 Aug 92 07:40:48 GMT
- |>
- |> 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@prism.poly.edu
- |>
- |>
-
- FWIW, I just tried the syntax above on Rdb/VMS and it worked.
-
-
- Piotr
-