CREATE TABLE MST
(
MST_LCODE CHAR(1) NOT NULL,
MST_INQUIRYCODE CHAR(1),
MST_ORDER NUMBER(2,0),
MST_SCREEN NUMBER(2,0),
CONSTRAINT PK_MST_MST PRIMARY KEY (MST_LCODE)
)
insert into MST values ('L','L','1','1')
insert into MST values ('S','S','2','1')
insert into MST values ('C','C','3','1')
insert into MST values ('T','C','1','2')
insert into MST values ('P','P','2','2')
insert into MST values ('G','G','3','2')
insert into MST values ('M','C','1','3')
在上面的表中取MST_LCODE,重复的字段除去,按照MST_ORDER,MST_SCREEN排序,升序排
这样的要求在SQL中能实现吗
(
MST_LCODE CHAR(1) NOT NULL,
MST_INQUIRYCODE CHAR(1),
MST_ORDER NUMBER(2,0),
MST_SCREEN NUMBER(2,0),
CONSTRAINT PK_MST_MST PRIMARY KEY (MST_LCODE)
)
insert into MST values ('L','L','1','1')
insert into MST values ('S','S','2','1')
insert into MST values ('C','C','3','1')
insert into MST values ('T','C','1','2')
insert into MST values ('P','P','2','2')
insert into MST values ('G','G','3','2')
insert into MST values ('M','C','1','3')
在上面的表中取MST_LCODE,重复的字段除去,按照MST_ORDER,MST_SCREEN排序,升序排
这样的要求在SQL中能实现吗
(
MST_LCODE CHAR(1) NOT NULL,
MST_INQUIRYCODE CHAR(1),
MST_ORDER NUMBER(2,0),
MST_SCREEN NUMBER(2,0),
CONSTRAINT PK_MST_MST PRIMARY KEY (MST_LCODE)
)
insert into MST values ('L','L','1','1')
insert into MST values ('S','S','2','1')
insert into MST values ('C','C','3','1')
insert into MST values ('T','C','1','2')
insert into MST values ('P','P','2','2')
insert into MST values ('G','G','3','2')
insert into MST values ('M','C','1','3')
在上面的表中取MST_INQUIRYCODE,重复的字段除去,按照MST_ORDER,MST_SCREEN排序,升序排
这样的要求在SQL中能实现吗
不好意思是取第二个字段,谢谢了
最后结果怎么会是 L S C P G
?
select * from MST order by MST_SCREEN,MST_ORDER)
取出来的结果好像不对阿
select * from MST order by MST_SCREEN,MST_ORDER) order by MST_SCREEN,MST_ORDER