Oracle-L: RE: RE: interesting sql question

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 29 Sep 2003 08:29:40 -0800
Message-ID: <F001.005D1608.20030929082940@fatcity.com>

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 !
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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 - 11:29:40 CDT