Oracle-L: RE: RE: interesting sql question

From: <rgaffuri_at_cox.net>
Date: Mon, 29 Sep 2003 09:09:48 -0800
Message-ID: <F001.005D160E.20030929090948@fatcity.com>

no there are examples in the book using where 'not exists'. the query was horrible. Ill post it later if you want to see how bad it is.

no its not homework. Id get the answer wrong if i did it this way, since Id have to follow the model in the book. Which is terrible.
>
> From: "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
> Date: 2003/09/29 Mon PM 12:29:40 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: RE: interesting sql question
>
> yeah! I think it *is* homework!!!! :)
>
> Tom
>
>
> -----Original Message-----
> Sent: Monday, September 29, 2003 12:10 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hey ... the question wasn't complete ...
>
> give us the full statement of the question ...
> <g>
> Raj
> ----------------------------------------------------------------------------
> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
> -----Original Message-----
>
> Sent: Monday, September 29, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> a user may request the same boat more than once. not sure that work.
> >
> > From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
> > Date: 2003/09/29 Mon AM 10:34:53 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: RE: RE: interesting sql question
> >
> > Here is an attempt ...
> >
> > select p.*
> > from persons p
> > where sid in
> > (select sid, count(bid)
> > from bids
> > group by sid
> > having count(sid) = (select count(boad_id) from boats))
> > /
> >
> > You wanted to find all persons who have booked all boats ... add criteria
> > for booked in the first sub-query.
> >
> > Raj
> >
> ----------------------------------------------------------------------------
>
> > ----
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly personal.
> > QOTD: Any clod can have facts, having an opinion is an art !
> >
> >
>
>
>

RE: RE: interesting sql question

yeah! I think it *is* homework!!!! :)

Tom

-----Original Message-----
From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni@espn.com]
Sent: Monday, September 29, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: interesting sql question

Hey ... the question wasn't complete ...

give us the full statement of the question ...
<g>
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: rgaffuri@cox.net [mailto:rgaffuri@cox.net]
Sent: Monday, September 29, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: interesting sql question

a user may request the same boat more than once. not sure that work.
>
> From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@espn.com>
> Date: 2003/09/29 Mon AM 10:34:53 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
> Subject: RE: RE: interesting sql question
>
> Here is an attempt ...
>
> select p.*
> from persons p
> where sid in
>      (select sid, count(bid)
>         from bids
>        group by sid
>       having count(sid) = (select count(boad_id) from boats))
> /
>
> You wanted to find all persons who have booked all boats ... add criteria
> for booked in the first sub-query.
>
> Raj
> ----------------------------------------------------------------------------
> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Sep 29 2003 - 12:09:48 CDT