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

Abhi Sharma Apr 9, 2022 0 28

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

Abhi Sharma

Staff asked 1 month ago

1 Vote Up Vote Down

Chand Dakhara

Staff answered 1 month ago

Try the below query

select * from YOUR_TABLE_NAME FOR JSON PATH

Abhi Sharma