T-SQL Window functions: for data analysis and beyond
"Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to han...
Gespeichert in:
1. Verfasser: | |
---|---|
Format: | Buch |
Sprache: | English |
Veröffentlicht: |
Redmond, Washington
Microsoft
[2020]
Pearson Education [2020] |
Ausgabe: | Second edition |
Schriftenreihe: | Professional
|
Schlagworte: | |
Zusammenfassung: | "Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You'll find a detailed section on optimization, plus an extensive collection of business solutions -- including novel techniques available in no other book."--provided by publisher |
Beschreibung: | Includes index |
Beschreibung: | xiv, 327 pages illustrations 23 cm |
ISBN: | 9780135861448 0135861446 |
Internformat
MARC
LEADER | 00000nam a2200000 c 4500 | ||
---|---|---|---|
001 | BV046706199 | ||
003 | DE-604 | ||
005 | 20200602 | ||
007 | t | ||
008 | 200506s2020 a||| |||| 00||| eng d | ||
020 | |a 9780135861448 |9 978-0-13-586144-8 | ||
020 | |a 0135861446 |9 0-13-586144-6 | ||
035 | |a (OCoLC)1164615762 | ||
035 | |a (DE-599)BVBBV046706199 | ||
040 | |a DE-604 |b ger |e rda | ||
041 | 0 | |a eng | |
049 | |a DE-29T | ||
100 | 1 | |a Ben-Gan, Itzik |e Verfasser |4 aut | |
245 | 1 | 0 | |a T-SQL Window functions |b for data analysis and beyond |c Itzik Ben-Gan |
250 | |a Second edition | ||
264 | 1 | |a Redmond, Washington |b Microsoft |c [2020] | |
264 | 1 | |b Pearson Education |c [2020] | |
300 | |a xiv, 327 pages |b illustrations |c 23 cm | ||
336 | |b txt |2 rdacontent | ||
337 | |b n |2 rdamedia | ||
338 | |b nc |2 rdacarrier | ||
490 | 0 | |a Professional | |
500 | |a Includes index | ||
505 | 8 | |a SQL Windowing -- A Detailed Look at Window Functions -- Ordered Set Functions -- Row-Pattern Recognition in SQL -- Optimization of Window Functions -- T-SQL Solutions Using Window Functions | |
520 | 3 | |a "Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You'll find a detailed section on optimization, plus an extensive collection of business solutions -- including novel techniques available in no other book."--provided by publisher | |
653 | |a SQL server | ||
653 | 0 | |a SQL (Computer program language) | |
653 | 0 | |a Client/server computing | |
653 | 0 | |a Database management | |
653 | |a SQL server | ||
653 | 0 | |a Client/server computing | |
653 | 0 | |a Database management | |
653 | 0 | |a SQL (Computer program language) | |
999 | |a oai:aleph.bib-bvb.de:BVB01-032116661 |
Datensatz im Suchindex
_version_ | 1804181437683859456 |
---|---|
adam_txt | |
any_adam_object | |
any_adam_object_boolean | |
author | Ben-Gan, Itzik |
author_facet | Ben-Gan, Itzik |
author_role | aut |
author_sort | Ben-Gan, Itzik |
author_variant | i b g ibg |
building | Verbundindex |
bvnumber | BV046706199 |
contents | SQL Windowing -- A Detailed Look at Window Functions -- Ordered Set Functions -- Row-Pattern Recognition in SQL -- Optimization of Window Functions -- T-SQL Solutions Using Window Functions |
ctrlnum | (OCoLC)1164615762 (DE-599)BVBBV046706199 |
edition | Second edition |
format | Book |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02126nam a2200433 c 4500</leader><controlfield tag="001">BV046706199</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20200602 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">200506s2020 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780135861448</subfield><subfield code="9">978-0-13-586144-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0135861446</subfield><subfield code="9">0-13-586144-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1164615762</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV046706199</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-29T</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Ben-Gan, Itzik</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">T-SQL Window functions</subfield><subfield code="b">for data analysis and beyond</subfield><subfield code="c">Itzik Ben-Gan</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Redmond, Washington</subfield><subfield code="b">Microsoft</subfield><subfield code="c">[2020]</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="b">Pearson Education</subfield><subfield code="c">[2020]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xiv, 327 pages</subfield><subfield code="b">illustrations</subfield><subfield code="c">23 cm</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="490" ind1="0" ind2=" "><subfield code="a">Professional</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">SQL Windowing -- A Detailed Look at Window Functions -- Ordered Set Functions -- Row-Pattern Recognition in SQL -- Optimization of Window Functions -- T-SQL Solutions Using Window Functions</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">"Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You'll find a detailed section on optimization, plus an extensive collection of business solutions -- including novel techniques available in no other book."--provided by publisher</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">SQL server</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Client/server computing</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Database management</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">SQL server</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Client/server computing</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Database management</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-032116661</subfield></datafield></record></collection> |
id | DE-604.BV046706199 |
illustrated | Illustrated |
index_date | 2024-07-03T14:29:58Z |
indexdate | 2024-07-10T08:51:39Z |
institution | BVB |
isbn | 9780135861448 0135861446 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-032116661 |
oclc_num | 1164615762 |
open_access_boolean | |
owner | DE-29T |
owner_facet | DE-29T |
physical | xiv, 327 pages illustrations 23 cm |
publishDate | 2020 |
publishDateSearch | 2020 |
publishDateSort | 2020 |
publisher | Microsoft Pearson Education |
record_format | marc |
series2 | Professional |
spelling | Ben-Gan, Itzik Verfasser aut T-SQL Window functions for data analysis and beyond Itzik Ben-Gan Second edition Redmond, Washington Microsoft [2020] Pearson Education [2020] xiv, 327 pages illustrations 23 cm txt rdacontent n rdamedia nc rdacarrier Professional Includes index SQL Windowing -- A Detailed Look at Window Functions -- Ordered Set Functions -- Row-Pattern Recognition in SQL -- Optimization of Window Functions -- T-SQL Solutions Using Window Functions "Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You'll find a detailed section on optimization, plus an extensive collection of business solutions -- including novel techniques available in no other book."--provided by publisher SQL server SQL (Computer program language) Client/server computing Database management |
spellingShingle | Ben-Gan, Itzik T-SQL Window functions for data analysis and beyond SQL Windowing -- A Detailed Look at Window Functions -- Ordered Set Functions -- Row-Pattern Recognition in SQL -- Optimization of Window Functions -- T-SQL Solutions Using Window Functions |
title | T-SQL Window functions for data analysis and beyond |
title_auth | T-SQL Window functions for data analysis and beyond |
title_exact_search | T-SQL Window functions for data analysis and beyond |
title_exact_search_txtP | T-SQL Window functions for data analysis and beyond |
title_full | T-SQL Window functions for data analysis and beyond Itzik Ben-Gan |
title_fullStr | T-SQL Window functions for data analysis and beyond Itzik Ben-Gan |
title_full_unstemmed | T-SQL Window functions for data analysis and beyond Itzik Ben-Gan |
title_short | T-SQL Window functions |
title_sort | t sql window functions for data analysis and beyond |
title_sub | for data analysis and beyond |
work_keys_str_mv | AT benganitzik tsqlwindowfunctionsfordataanalysisandbeyond |