SQL:2016 or ISO/IEC 9075:2016 (under the general title "Information technology - Database languages - SQL") is the eighth revision of the ISO (1987) and ANSI (1986) standard for the SQL database query language. It was formally adopted in December 2016.[1] The standard consists of 9 parts which are described in some detail in SQL.

New features

SQL:2016 introduced 44 new optional features.[2] 22 of them belong to the JSON functionality, ten more are related to polymorphic table functions. The additions to the standard include:

  • JSON: Functions to create JSON documents, to access parts of JSON documents and to check whether a string contains valid JSON data
  • Row Pattern Recognition: Matching a sequence of rows against a regular expression pattern
  • Date and time formatting and parsing
  • LISTAGG: A function to transform values from a group of rows into a delimited string
  • Polymorphic table functions: table functions without predefined return type
  • New data type DECFLOAT

See also


  1. ^ "ISO/IEC 9075, 13249, and others". Retrieved .
  2. ^ "What's New in SQL:2016". Retrieved .

External links

  This article uses material from the Wikipedia page available here. It is released under the Creative Commons Attribution-Share-Alike License 3.0.



Connect with defaultLogic
What We've Done
Led Digital Marketing Efforts of Top 500 e-Retailers.
Worked with Top Brands at Leading Agencies.
Successfully Managed Over $50 million in Digital Ad Spend.
Developed Strategies and Processes that Enabled Brands to Grow During an Economic Downturn.
Taught Advanced Internet Marketing Strategies at the graduate level.

Manage research, learning and skills at defaultlogic.com. Create an account using LinkedIn to manage and organize your omni-channel knowledge. defaultlogic.com is like a shopping cart for information -- helping you to save, discuss and share.

  Contact Us