SQL in a nutshell: [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server]
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing ; Köln [u.a.]
O'Reilly
2009
|
| Ausgabe: | 3. ed. |
| Schlagworte: | |
| Online-Zugang: | Verlagsinformation Cover Inhaltsverzeichnis |
| Beschreibung: | XII, 578 S. |
| ISBN: | 9780596518844 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV036086727 | ||
| 003 | DE-604 | ||
| 005 | 20100325 | ||
| 007 | t | ||
| 008 | 100319s2009 |||| 00||| eng d | ||
| 020 | |a 9780596518844 |9 978-0-596-51884-4 | ||
| 024 | 3 | |a 9780596518844 | |
| 035 | |a (OCoLC)316250833 | ||
| 035 | |a (DE-599)BSZ298806576 | ||
| 040 | |a DE-604 |b ger | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-703 |a DE-526 | ||
| 082 | 0 | |a 005.7585 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Kline, Kevin E. |d 1966- |e Verfasser |0 (DE-588)123235375 |4 aut | |
| 245 | 1 | 0 | |a SQL in a nutshell |b [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] |c Kevin E. Kline with Daniel Kline and Brand Hunt |
| 250 | |a 3. ed. | ||
| 264 | 1 | |a Beijing ; Köln [u.a.] |b O'Reilly |c 2009 | |
| 300 | |a XII, 578 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 630 | 0 | 4 | |a SQL server |
| 650 | 4 | |a Client/server computing | |
| 650 | 0 | 7 | |a Befehlsvorrat |0 (DE-588)4129931-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL-2003 |0 (DE-588)4800549-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL-99 |0 (DE-588)4602628-9 |2 gnd |9 rswk-swf |
| 655 | 7 | |0 (DE-588)4188171-0 |a Verzeichnis |2 gnd-content | |
| 689 | 0 | 0 | |a SQL-2003 |0 (DE-588)4800549-6 |D s |
| 689 | 0 | 1 | |a Befehlsvorrat |0 (DE-588)4129931-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 1 | 1 | |a Befehlsvorrat |0 (DE-588)4129931-0 |D s |
| 689 | 1 | |8 1\p |5 DE-604 | |
| 689 | 2 | 0 | |a SQL-99 |0 (DE-588)4602628-9 |D s |
| 689 | 2 | 1 | |a Befehlsvorrat |0 (DE-588)4129931-0 |D s |
| 689 | 2 | |8 2\p |5 DE-604 | |
| 700 | 1 | |a Kline, Daniel |e Verfasser |4 aut | |
| 700 | 1 | |a Hunt, Brand |e Verfasser |4 aut | |
| 856 | 4 | |q text/html |u http://swbplus.bsz-bw.de/bsz10686419xvlg.htm |3 Verlagsinformation | |
| 856 | 4 | |m DE-576;oReilly |q image/jpeg |u http://swbplus.bsz-bw.de/bsz298806576cov.htm |v 20090123115240 |3 Cover | |
| 856 | 4 | 2 | |m Digitalisierung UB Bayreuth |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018977674&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-018977674 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 2\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
Datensatz im Suchindex
| _version_ | 1804141147692466176 |
|---|---|
| adam_text | Table
of
Contents
Preface
..........................................................
v
1.
SQL History and Implementations
.............................1
The Relational Model and ANSI SQL
2
History of the SQL Standard
10
SQL Dialects
14
2.
Foundational Concepts
......................................16
Database Platforms Described in This Book
16
Categories of Syntax
17
SQL2003 and Platform-Specific Datatypes
29
Constraints
50
3.
SQL Statement Command Reference
..........................59
How to Use This Chapter
59
SQL Platform Support
60
SQL Command Reference
63
4.
SQL Functions
.............................................437
Types of Functions
437
ANSI SQL Aggregate Functions
438
ANSI SQL Window Functions
455
ANSI SQL Scalar Functions
463
Platform-Specific Extensions
483
Appendix:
Shared and Platform-Specific Keywords
..................547
Index
..........................................................555
iv
I Table of Contents
|
| any_adam_object | 1 |
| author | Kline, Kevin E. 1966- Kline, Daniel Hunt, Brand |
| author_GND | (DE-588)123235375 |
| author_facet | Kline, Kevin E. 1966- Kline, Daniel Hunt, Brand |
| author_role | aut aut aut |
| author_sort | Kline, Kevin E. 1966- |
| author_variant | k e k ke kek d k dk b h bh |
| building | Verbundindex |
| bvnumber | BV036086727 |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)316250833 (DE-599)BSZ298806576 |
| dewey-full | 005.7585 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7585 |
| dewey-search | 005.7585 |
| dewey-sort | 15.7585 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 3. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02400nam a2200577 c 4500</leader><controlfield tag="001">BV036086727</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20100325 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">100319s2009 |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780596518844</subfield><subfield code="9">978-0-596-51884-4</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9780596518844</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)316250833</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BSZ298806576</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-703</subfield><subfield code="a">DE-526</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7585</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kline, Kevin E.</subfield><subfield code="d">1966-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)123235375</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL in a nutshell</subfield><subfield code="b">[a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server]</subfield><subfield code="c">Kevin E. Kline with Daniel Kline and Brand Hunt</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">3. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing ; Köln [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2009</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XII, 578 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Client/server computing</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Befehlsvorrat</subfield><subfield code="0">(DE-588)4129931-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL-2003</subfield><subfield code="0">(DE-588)4800549-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL-99</subfield><subfield code="0">(DE-588)4602628-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="0">(DE-588)4188171-0</subfield><subfield code="a">Verzeichnis</subfield><subfield code="2">gnd-content</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL-2003</subfield><subfield code="0">(DE-588)4800549-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Befehlsvorrat</subfield><subfield code="0">(DE-588)4129931-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Befehlsvorrat</subfield><subfield code="0">(DE-588)4129931-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">SQL-99</subfield><subfield code="0">(DE-588)4602628-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2="1"><subfield code="a">Befehlsvorrat</subfield><subfield code="0">(DE-588)4129931-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="8">2\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kline, Daniel</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Hunt, Brand</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="q">text/html</subfield><subfield code="u">http://swbplus.bsz-bw.de/bsz10686419xvlg.htm</subfield><subfield code="3">Verlagsinformation</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="m">DE-576;oReilly</subfield><subfield code="q">image/jpeg</subfield><subfield code="u">http://swbplus.bsz-bw.de/bsz298806576cov.htm</subfield><subfield code="v">20090123115240</subfield><subfield code="3">Cover</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bayreuth</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018977674&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-018977674</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield></record></collection> |
| genre | (DE-588)4188171-0 Verzeichnis gnd-content |
| genre_facet | Verzeichnis |
| id | DE-604.BV036086727 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T22:11:15Z |
| institution | BVB |
| isbn | 9780596518844 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-018977674 |
| oclc_num | 316250833 |
| open_access_boolean | |
| owner | DE-703 DE-526 |
| owner_facet | DE-703 DE-526 |
| physical | XII, 578 S. |
| publishDate | 2009 |
| publishDateSearch | 2009 |
| publishDateSort | 2009 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Kline, Kevin E. 1966- Verfasser (DE-588)123235375 aut SQL in a nutshell [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] Kevin E. Kline with Daniel Kline and Brand Hunt 3. ed. Beijing ; Köln [u.a.] O'Reilly 2009 XII, 578 S. txt rdacontent n rdamedia nc rdacarrier SQL server Client/server computing Befehlsvorrat (DE-588)4129931-0 gnd rswk-swf SQL (DE-588)4134010-3 gnd rswk-swf SQL-2003 (DE-588)4800549-6 gnd rswk-swf SQL-99 (DE-588)4602628-9 gnd rswk-swf (DE-588)4188171-0 Verzeichnis gnd-content SQL-2003 (DE-588)4800549-6 s Befehlsvorrat (DE-588)4129931-0 s DE-604 SQL (DE-588)4134010-3 s 1\p DE-604 SQL-99 (DE-588)4602628-9 s 2\p DE-604 Kline, Daniel Verfasser aut Hunt, Brand Verfasser aut text/html http://swbplus.bsz-bw.de/bsz10686419xvlg.htm Verlagsinformation DE-576;oReilly image/jpeg http://swbplus.bsz-bw.de/bsz298806576cov.htm 20090123115240 Cover Digitalisierung UB Bayreuth application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018977674&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 2\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Kline, Kevin E. 1966- Kline, Daniel Hunt, Brand SQL in a nutshell [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] SQL server Client/server computing Befehlsvorrat (DE-588)4129931-0 gnd SQL (DE-588)4134010-3 gnd SQL-2003 (DE-588)4800549-6 gnd SQL-99 (DE-588)4602628-9 gnd |
| subject_GND | (DE-588)4129931-0 (DE-588)4134010-3 (DE-588)4800549-6 (DE-588)4602628-9 (DE-588)4188171-0 |
| title | SQL in a nutshell [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] |
| title_auth | SQL in a nutshell [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] |
| title_exact_search | SQL in a nutshell [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] |
| title_full | SQL in a nutshell [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] Kevin E. Kline with Daniel Kline and Brand Hunt |
| title_fullStr | SQL in a nutshell [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] Kevin E. Kline with Daniel Kline and Brand Hunt |
| title_full_unstemmed | SQL in a nutshell [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] Kevin E. Kline with Daniel Kline and Brand Hunt |
| title_short | SQL in a nutshell |
| title_sort | sql in a nutshell a desktop quick reference covers mysql oracle postgresql and sql server |
| title_sub | [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server] |
| topic | SQL server Client/server computing Befehlsvorrat (DE-588)4129931-0 gnd SQL (DE-588)4134010-3 gnd SQL-2003 (DE-588)4800549-6 gnd SQL-99 (DE-588)4602628-9 gnd |
| topic_facet | SQL server Client/server computing Befehlsvorrat SQL SQL-2003 SQL-99 Verzeichnis |
| url | http://swbplus.bsz-bw.de/bsz10686419xvlg.htm http://swbplus.bsz-bw.de/bsz298806576cov.htm http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018977674&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT klinekevine sqlinanutshelladesktopquickreferencecoversmysqloraclepostgresqlandsqlserver AT klinedaniel sqlinanutshelladesktopquickreferencecoversmysqloraclepostgresqlandsqlserver AT huntbrand sqlinanutshelladesktopquickreferencecoversmysqloraclepostgresqlandsqlserver |