no name ----------- x1 wade 2d james pk kobe aa KG
希望结果为
no name no name ------------------------- x1 wade 2d james px kobe aa KG
SQL code: create table tb (no varchar(5),name varchar(10)) insert tb select 'x1', 'wade' union all select '2d', 'james' union all select 'pk', 'kobe' union all select 'aa', 'KG'
select max(no1) no ,max(name1) name,max(no2) no ,max(name2) name from ( select (row_number()over(order by getdate())-1)/2 rn, (case when row_number()over(order by getdate())%2=1 then no else '' end) no1, (case when row_number()over(order by getdate())%2=1 then name else '' end) name1, (case when row_number()over(order by getdate())%2=0 then no else '' end) no2, (case when row_number()over(order by getdate())%2=0 then name else '' end) name2 from tb ) t group by rn
/* no name no name ----- ---------- ----- ---------- x1 wade 2d james pk kobe aa KG
select o_customer,o_price from orders having o_price >=avg(o_price) select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders) 我感觉没有区别啊，怎么在mysql会有 ......
rs.open "select * from guide where city_name='北京' order by pai desc",conn,1,1 do while not rs.eof or rs.bof 。。 。。 。。 rs.movenext loop 这个sql语句在wap站里 本身有 ......
