SQL Anywhere 17 is a SAP Database. Some of the earlier versions were released by SYBASE.
In SQL Anywhere 17 you have three different ways of getting JSON formatted data / JSON document.
You can use the FOR JSON clause with:
You run SQL Queries in Interactive SQL. Here is an example of a query that provides json document using the FOR JSON AUTO clause.
InteractiveSQL17JSON
In SQL Anywhere 17 you have three different ways of getting JSON formatted data / JSON document.
You can use the FOR JSON clause with:
- SELECT Statement
- Subqueries
- Queries having Group By clause
- Aggregate Functions and
- Views
- Scalar elements
- Objects
- Arrays
- For JSON Raw
- For JSON AUTO
- For JSON Explicit
You run SQL Queries in Interactive SQL. Here is an example of a query that provides json document using the FOR JSON AUTO clause.
InteractiveSQL17JSON
No comments:
Post a Comment