将一个文件中的每两行合并成一行，用什么方法最简单？


xargs -l2 < file.txt | more

          
awk '{if(NR%2==0){printf $0 "\n"}else{printf "%s：",$0}}' file
sed 'N;s/\n/ :/' file

				
转载于:https://blog.51cto.com/soige/1717516

MySQL中把两行数据合并成一行：

select username,group_concat(userid) as re_id  from tablename  group by userid

1.输入



2.输出



 

3. 查询代码  listagg

SELECT s.Stuid,
       listagg(stuname, ',') within group(order by Stuid) stuname,
       s.Stusex 
  FROM T_STU s
 group by s.Stuid, s.Stusex

或者 用 wm_concat

SELECT s.Stuid,
       to_char(wm_concat(stuname)),
       s.Stusex 
  FROM T_STU s
 group by s.Stuid, s.Stusex