oracle总结

oracle 简单总结

Select

1	SELECT column_1 FROM table_name；

1 2	SELECT customer_id,name FROM customers;

select语句中最后一个子句

1	SELECT column_1 FROM table_name ORDER BY column_1 [ASC \| DESC] [NULLS FIRST \| NULLS LAST],；

过滤结果集中的重复行

1	SELECT DISTINCT column_1 FROM table_name;

过滤符合条件的行记录

1	SELECT product_name FROM products WHERE product_name = 'Kingston';

组合条件

SELECT
    product_name,
    list_price
FROM
    products
WHERE
    list_price > 500
    AND category_id = 4;

选取在指定范围内

SELECT 
	product_name,
	list_price
FROM
	products
WHERE
	list_price BETWEEN 65 AND 80
ORDER BY
	list_price;

选取符合列表中的记录

SELECT
	product_name,
	category_id
FROM
	products
WHERE
	category_id IN(1,4)
ORDER BY
	product_name;