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

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.

主站蜘蛛池模板: 外汇| 虞城县| 自贡市| 凤翔县| 平乐县| 资中县| 祁门县| 库尔勒市| 垫江县| 武邑县| 长岛县| 琼海市| 合作市| 瑞安市| 喀喇| 克山县| 集安市| 大城县| 景泰县| SHOW| 县级市| 东方市| 宁夏| 师宗县| 大邑县| 民县| 玉田县| 凉城县| 绥化市| 建湖县| 沙湾县| 顺义区| 浙江省| 新乐市| 阿瓦提县| 林西县| 兴安县| 合肥市| 舒城县| 阿坝县| 依安县|