1. 普通查询
select * from test_table
2. 转为Json
方法:添加 FOR JSON PATH语句
select * from test_table
for json path
[{
"iid": 1,
"value": 2
}, {
"iid": 2,
"value": 0
}, {
"iid": 1,
"value": 2
}, {
"iid": 2
}, {
"iid": 1,
"value": 2
}, {
"iid": 2,
"value": 2
}]
3. 添加ROOT标记
select * from test_table
for json path,root('root')