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

  • Mastering PostgreSQL 9.6
  • Hans Jurgen Schonig
  • 117字
  • 2021-07-09 19:57:24

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.

主站蜘蛛池模板: 新平| 乳源| 蛟河市| 且末县| 淮阳县| 奉新县| 舟山市| 轮台县| 德格县| 东乌珠穆沁旗| 武山县| 肇州县| 韶山市| 如皋市| 谷城县| 五大连池市| 新和县| 达孜县| 禹州市| 英山县| 隆尧县| 和平县| 东乡| 玛纳斯县| 长丰县| 盖州市| 化德县| 桓仁| 张家口市| 澄城县| 漠河县| 温泉县| 潼关县| 西盟| 霍州市| 宝兴县| 东丽区| 盐边县| 洮南市| 尚志市| 辰溪县|