第2-3课 检索数据检索列检索排序数据

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;