3. Oracle – SQL – Summary

09Mar11

小總結:

SQL 大致上的格式
Select distinct name from table
where a.a=b.b and in a.b in ( SQL )
group by a.c
having avg(a.a) > 10

create table
(att1 varchar(8),
att2 numeric(4,0),
primary key att3 (att1)
check (att2 in ( 'Fall','spring'))
);

Filed under: 隨想   |  Leave a Comment