需求:查询数据时,某列的值都一样/固定
实现
1、SQL:id与name是表里的属性,而field1和field2是查询结果的任意别名
--field1和field2为任意别名
select id,'' AS "field1",'哈哈' AS "field2",name FROM SYS_USER
2、结果
1、SQL:id与name是表里的属性,而field1和field2是查询结果的任意别名
--field1和field2为任意别名
select id,'' AS "field1",'哈哈' AS "field2",name FROM SYS_USER
2、结果