concat() 函数
字符串连接函数
其中可以放多个字段,将字段拼接起来
SELECT term_prin,term_repay_prin,term_reduce_prin,CONCAT(term_prin,term_repay_prin,term_reduce_prin) as '当前逾期本金' FROM acc_repay.repayment_plan WHERE due_bill_no ='YX-202101101214472620066' AND term_status = 'OVERDUE';
结果如下:
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5yM3gTO5ETYjlDZ2cjN3cDOyYzX0MzNwkTMwIzLcVDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
group_concat() 函数
这个函数在hive中使用不了