将数据二维显示

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