qq_40477943的博客

select code_name from test.json_test where code_name='{"code":"1","name":"张无忌"}';结果》》{"code":"1","name":"张无忌"}select get_json_object(code_name,'$.code') code,get_json_object(code_name,'$.name') namefrom test.json_test wherecode_name='{"code":"1","na...

现有一个表student：select * from student;然后加上一列序号：select row_number() over(partition by 1) as xuhao,a.*from student a;得到结果：