34,590
社区成员
发帖
与我相关
我的任务
分享
select a,b from #list order by b
insert into list values ('7','9','8')
select distinct(c) from #list order by c desc
select A,B from list where B order by asc
insert into list(a,b,c) values(7,8,9)
select distinct (c) from list where c order by c desc
select A,B from list where B order by asc
insert into list(a,b,c) values(7,8,9)
select distinct (c) from list where c order b
--1. 选出A,B字段值,并按B的升序排列
select a,b from list order by b asc -- order by 默认排序为asc, 如为升序,可以不写asc
--2. 插入一条记录(7,9,8)
insert list select 7,9,8
--3.选出C值,并按的C降序排列,并消除重复值
select distinct c from list order by c desc
if object_id('list')is not null drop table list
go
create table List(A int, B int,C int)
insert list select 3 , 7, 9
insert list select 4 , 8 , 4
insert list select 5, 6 , 9
--1
select a,b from list order by b asc
--2
insert list select 7,9,8
--3
select distinct c from list order by c desc
/*a b
----------- -----------
5 6
3 7
4 8
c
-----------
9
8
4*/
--1
select a,b from list order by b asc
--2
insert list select 7,9,8
--3
select distinct c from list order by c desc