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 month ago

Answers (1)

Add Answer
Staff answered 1 month ago

Try the below query

select * from YOUR_TABLE_NAME FOR JSON PATH

 

Subscribe

Select Categories