Thread: off Topic: Looking for a good sql query

off Topic: Looking for a good sql query

From
Jamie Deppeler
Date:
Hi,

This post is a bit off topic im looking a good sql book can someone give
me a recommendation?


Re: off Topic: Looking for a good sql query

From
jseymour@linxnet.com (Jim Seymour)
Date:
Jamie Deppeler <jamie@doitonce.net.au> wrote:
>
> Hi,
>
> This post is a bit off topic im looking a good sql book can someone give
> me a recommendation?

I was pleased with...

The Practical SQL Handbook
Third Edition
Judith S. Bowman, Sandra L. Emerson, & Marcy Darnovsky
Addison-Wesley Developers Press
A Division of Addison Wesley Longman, Inc.
ISBN: 0-201-44787-8 (softcover, incl. CD-ROM)

There's a 4th Edition out now.  Here's Bookpool's listing:

http://www.bookpool.com/.x/mrbet2p3z1/ss?qs=The+Practical+SQL+Handbook&x=0&y=0

I'm toying with the idea of selling, donating or trading-in my 3rd
edition and picking-up the 4th.

Jim

Re: off Topic: Looking for a good sql query

From
felix@crowfix.com
Date:
On Fri, Nov 26, 2004 at 01:19:59PM +1100, Jamie Deppeler wrote:

> This post is a bit off topic im looking a good sql book can someone give
> me a recommendation?

I am a middling SQL guy; I have used functions, triggers, outer joins,
etc, but not often.  But I've been doing that for years :-) my
personal favorite is SQL Visual Quickstart Guide, Chris Fehily,
Peachpit Press, 2002, ISBN 0-201-11803-0.  It has lots of examples, it
remains steadily boring and consistent throughout, it goes from really
basic stuff to pretty fancy stuff, and most precious of all, it covers
five databases and tells you exactly how every single example differs
from db to db --

    MS Access
    MS SQL Server
    MySQL
    Oracle
    PostgreSQL

If I only had one SQL book, this would be it.

--
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o