创建表:
create table stu(
son number,
sname varchar2(30) not null,
email varchar2(30) not null,
gender char(2),
constraint pk primary key(son),
constraint uemail unique(email),
constraint sex check (gender in('男','女'))
);
添加数据:
insert into stu(son,sname,email,gender) values(1,'狗蛋','wrd','男');
查询数据:
select * from stu;
distinct去重:
select distinct sname from stu
注意地方:
1.group by having order by desc (规则顺序)
2.查询条件中有函数时,必须都为函数,语法规则 如果有普通的列,在后用group by 将其分组
3.union取出两条查询结果的并集,并去除重复数据
4.interscet去除两条结果的交集