How to get json output from sql cells?

D

D

dienerie2020-09-29 16:44:42

SQL

dienerie, 2020-09-29 16:44:42

How to get json output from sql cells?

How can I get from certain columns, view get json

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

vilinyh, 2020-09-29
@vilinyh

- MySQL - json_object/json_array,
- MS SQL Server - SELECT [...] FOR JSON
- PostgreSQL - json_build_object/json_agg
- for any RDBMS without JSON support - by normal concatenation.
Or post-processing the values selected by the query in any language.

Similar questions

R

Roman Tuzov2021-03-22 23:47:34

How to count from 0 and beyond? 3Reply

S

strelkovandreyv2019-09-10 07:09:07

What is the PHP file manager with the ability to connect via SMB to Windows share? 2Reply

S

Sergey Eremin2013-05-31 13:56:51

Multilingual site… not a blog… how? 4Reply

V

vrazbros2018-06-13 10:30:14

How do indexes affect updating deleting records? 2Reply

V

Vadim Stepanenko2021-09-14 22:46:57

How to write a sql query with a condition? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question