这两课主要介绍sql中利用select语句对数据的简单检索。 下面分别讨论不同类型的检索
select prod_id
from Products;
select prod_id, prod_name, prod_price
from Products;
select *
from Products;
select distinct vend_id
from products;
select prod_name
from products
limit 5;
select prod_name
from products
limit 5 offset 5;
select prod_name
from products
order by prod_name;
select prod_id, prod_price,prod_name
from products
order by prod_price,prod_name;
select prod_id, prod_price,prod_name
from products
order by prod_price desc, prod_name;