简单实例讲解SQL case语句!让你一看就明白~(二)
nsert into SC values(7, 12, 50);
insert into SC values(6, 3, 20);
insert into SC values(6, 6, 20);
insert into SC values(5, 1, 65);
insert into SC values(4, 13, 55);
insert into SC values(4, 5, 75);
insert into SC values(3, 3, 12);
insert into SC values(2, 3, 10);
insert into SC values(2, 1, 78);
insert into SC values(1, 1, 90);
insert into SC values(1, 2, 90);
insert into SC values(1, 3, 90);
insert into SC values(1, 4, 90);
insert into SC values(1, 5, 90);
insert into SC values(1, 6, 90);
insert into SC values(1, 7, 90);
insert into SC values(1, 8, 90);
insert into SC values(1, 9, 90);
insert into SC values(1, 10, 90);
insert into SC values(1, 11, 90);
insert into SC values(1, 12, 90);
insert into SC values(1, 13, 90);
select * from SC;
作者 liumeiqqzj