SQL中的基本语法

结构化查询语言（SQL）

建表：

create table newspaper(
feature varchar2(15) not null,
section char(1), 
page number
);

简单查询

select feature, section,page from newspaper; 

查询语句

select feature, section, page from newspaper 
where section = 'a' 
order by page desc, feature;

查看表结构

desc newspaper

LIKE

feature LIKE ‘Mo%’            FEATEUR 以字母Mo开头
feature LIKE '__I%'            FEATURE的第三个位置是1
feature LIKE '%o%o%'       FEATURE中有两个o

_（位标器）一个字符 %（通配符）0或任意字符