Help with Query

#11

On Nov 25, 9:52 am, "Jeff B" <jef... (AT) KnoSpam (DOT) tds.net> wrote:

Quote:

Hi everyone,

I have a book table and in that table it has the book tile, publisher, and
type of book it is. example mystery, scifi, etc...

I am trying to write a query that brings back a list of every pair of books
that have the same publisher and same book type. I have been able to get
the following code to work:

select publisher_code, type
from book
group by publisher_code, type
having count(*) > 1;

which returns the following results:

PU TYP
-- ---
JP MYS
LB FIC
PE FIC
PL FIC
ST SFI
VB FIC

I can not figure out how to get the book title and book code for the books
that this result list represents, everything i have tried throws out an
error.

Can someone help?

Thanks,

Jeff

cheater

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Help with Query

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Help with Query - 12-04-2007 , 05:01 PM