比如说select id,name from student返回
id name
001 john
002 mike我怎么写sql语句才能得到
id name result
001 john 001:john
002 mike 002:mike
id name
001 john
002 mike我怎么写sql语句才能得到
id name result
001 john 001:john
002 mike 002:mike
select id,name,id+':'+name as result from student