The majority of this slender book comprises eminently useful syntax documentation (which is in the style of Unix man pages, with bracketed options and monospace arguments) and the other information that's specific to individual statements and functions. Additionally, it includes a relatively small amount of conceptual information, such as a section on the proper use of NULL values. The material that's not statement-specific also contrasts data-type implementations of the four covered platforms--for example, readers learn that a PostgreSQL int2 value is known as a smallint in ANSI standard SQL. This is a particularly handy reference book, if you use one of the emphasized SQL implementations. --David Wall
Topics covered: Structured Query Language (SQL), as implemented in Oracle, Microsoft SQL Server, MySQL, and PostgreSQL, as well as in ANSI standard SQL (SQL92 and SQL99). After an introduction to data types and relational database fundamentals (the latter is not emphasized), the authors document SQL statements and functions, one by one and alphabetically. They take care to point out differences among the four implementations. --This text refers to an out of print or unavailable edition of this title.
This book offers a great cross-platform syntax reference for SQL.
This doesn't make the book useless to those using databases other than the four covered, it just means that not everything will work exactly the way the book says.
For every statement it shows you what the syntax should be according to the SQL99 Standard and how Oracle, MS-SQL Server, MySQL and PostgreSQL implement them.
Excellent book for describing the various flavors of SQL. It was really helpful in our transition from Oracle to PostGres.Published 23 days ago by Charles
I used an information how basic and intermediate level, to have it at hand and on my desk. If it is useful and practical.Published 2 months ago by Pablo Zurita
This book offers a great cross-platform syntax reference for SQL. It probably is not the easiest reference to use for finding the exact syntax for one particular DBMS; but it is... Read morePublished 5 months ago by Data Guy
I purchased this book for home and work. I loved the practice exercises. For a person learning SQL or any programming language these types of books are very helpful.Published 8 months ago by Shirley McCraw
This is a nice memory jog reference book. Fortunately, it covers many 'flavors' of SQL (SQL Server, Oracle, MySQL, etc) for each entry. Read morePublished 15 months ago by W. Culpepper
This book is more like SQL dictionary. Nice comparison of major SQL dialects, but not many samples and hard to read (function grouped not by use but go in a-z order.Published 15 months ago by Maxim Kazitov
Obviously I didn't sit down and read this book from cover to cover as doing so would have been extremely boring. Read morePublished on December 13, 2011 by Stephen Chapman
I like using this as a desk reference. Although I do have to agree with a previous reviewer who mentioned the examples are a little light. Read morePublished on March 17, 2011 by M. Johnson
I purchased this book because I work with several different database platforms, and I wanted a thorough reference that covered the syntax differences between platforms. Read morePublished on July 13, 2010 by Klauserator