Oracle数据库别名
程序员文章站
2022-06-02 13:42:10
创建users表;
输入select * from users;
合并两列值为一列,取别名users_info;
输入:select name || ','...
创建users表;
输入select * from users;
合并两列值为一列,取别名users_info;
输入:select name || ',' || age || '岁' AS users_info from users order by age,name;