I want to convert SQL data to JSON in sql. Can anyone tell me how to do?

Forums SQLI want to convert SQL data to JSON in sql. Can anyone tell me how to do?
Staff asked 1 year ago

Answers (1)

Add Answer
Staff answered 1 year ago

Try the below query

select * from YOUR_TABLE_NAME FOR JSON PATH

 

Subscribe

Select Categories

page-ad