官术网_书友最值得收藏!

Handling Advanced SQL

In the previous chapter, you learned about indexing as well as about PostgreSQL's ability to run custom indexing code to speedup queries. In this chapter you will learn about advanced SQL. Most readers of this book will have some experience of using SQL. However, experience has shown that those advanced features outlined in this book are not widely known and therefore it makes sense to cover them in this context to help people to achieve their goals faster and more efficiently.

The topics of this chapter are:

  • Grouping sets
  • Ordered sets
  • Hypothetical aggregates
  • Windowing functions and analytics

At the end of the chapter, you will be able to understand and use advanced SQL.

主站蜘蛛池模板: 贡嘎县| 平塘县| 新乡县| 桂东县| 张家界市| 万载县| 邳州市| 永仁县| 阿城市| 武穴市| 怀安县| 凌源市| 九龙县| 曲沃县| 新化县| 石河子市| 溧水县| 沂南县| 阜康市| 利津县| 科技| 贵溪市| 宝鸡市| 板桥市| 桐梓县| 平罗县| 尼玛县| 丽水市| 东乌珠穆沁旗| 吉木萨尔县| 佳木斯市| 噶尔县| 桓台县| 乌拉特后旗| 浙江省| 体育| 哈密市| 清水县| 千阳县| 咸宁市| 霍林郭勒市|