`

MySQL,SQL Server,Oracle中连接字符串的操作

    博客分类:
  • SQL
阅读更多
MySQL:
select concat(ename, ' is a ', job) from emp;

Oracle:
select ename || ' is a '|| job from emp;

SQL Server:
select (ename + ' is a ' + job) from emp;
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics