sql查询

select seri, max(case when insunit='℃' then hvalue end) as tvalue,max(case when insunit='%' then hvalue end) as hvalue from (SELECT substring(insname,1,(CHARINDEX('#',insname)-1)) as seri,insunit,hvalue  from JfDevIns where devid=56 and insunit is not null )as tb group by seri