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

Apr 9, 2022 0 85
ProfileImage

Abhi Sharma

  • 0
  • 580
  • 31
  • 89
Forums › SQL › I want to convert SQL data to JSON in sql. Can anyone tell me how to do?
loaderimage
0 Vote Up Vote Down
Abhi Sharma
Staff asked 6 months ago
Add comment

Answers (1)

Add Answer
loaderimage
1 Vote Up Vote Down
Chand Dakhara
Staff answered 6 months ago

Try the below query

select * from YOUR_TABLE_NAME FOR JSON PATH

 

Add comment
Add Answer

Subscribe

Select Categories