--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
1. select a , b from list order by b2. insert into list(a,b,c) values(7,9,8)3. select 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 8c ----------- 9 8 4*/
--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 像这样的查询是基本的操作,建议楼主有空把基础多加强加强,多动手操作
1.select a,b from list order by b asc 2.insert into list values (7,9,8) 3.select distinct c from list order by c desc
呵呵 select a,b from #list order by binsert 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 b
上边有写错内容 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 order by b asc
--2
insert list select 7,9,8
--3
select distinct c from list order by c desc
select a , b from list order by b2.
insert into list(a,b,c) values(7,9,8)3.
select c from list order by c desc
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 8c
-----------
9
8
4*/
--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
像这样的查询是基本的操作,建议楼主有空把基础多加强加强,多动手操作
2.insert into list
values (7,9,8)
3.select distinct c from list order by c desc
select a,b from #list order by binsert into list values ('7','9','8') select distinct(c) from #list order by c desc
insert into list(a,b,c) values(7,8,9)
select distinct (c) from list where c order b
上边有写错内容
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