将数据二维显示

create database lieceshi

use lieceshi

create table erwei
(
    Telenumber varchar(20) not null,
    Functio varchar(20) not null,
    Expenses  int not null
)
go

insert  into erwei(Telenumber,Functio,Expenses) values('2121270','月租','14')
insert  into erwei(Telenumber,Functio,Expenses) values('2121270','长途','21')
insert  into erwei(Telenumber,Functio,Expenses) values('2121270','短信','11')

select Telenumber as 电话号码,
max(case Functio when '月租' then Expenses else 0 end) as '月租费',
max(case Functio when '长途' then Expenses else 0 end) as '市话费',
max(case Functio when '短信' then Expenses else 0 end) as '长话费'
from erwei
group by Telenumber

select * from erwei

drop table erwei