off Topic: Looking for a good sql query

Started by Jamie Deppelerover 21 years ago3 messagesgeneral
Jump to latest
#1Jamie Deppeler
jamie@doitonce.net.au

Hi,

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

#2Jim Seymour
jseymour@LinxNet.com
In reply to: Jamie Deppeler (#1)
Re: off Topic: Looking for a good sql query

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&amp;x=0&amp;y=0

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

Jim

#3Felix Morley Finch
felix@crowfix.com
In reply to: Jamie Deppeler (#1)
Re: off Topic: Looking for a good sql query

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