数据库语言SQL
1.SQL中的简单查询
1.1 select-from-where
- from:给出查询所引用的关系
- where:条件字句,类似于关系代数中的选择条件
- select:决定满足条件的元组的哪些属性应该在结果中列出
1.2 SQL查询具有过程
对from字句关系中的每个元组,使用where字句中指定的条件进行筛选,然后投影到select字句中的属性或表达式列表上(注:SQL大小写无关)
示例:
去掉重复元组:
SELECT DINTINCT Sno FROM SC;
起别名:
SELECT title as name, length as duration FROM movies where studioname=“Disney” AND year=“1990”
计算:
SELECT title AS name, length*0.0166 as lengthHours FROM movies where studioname=“Disney” AND year=“1990”;
加新列加常量:
SELECT title AS name, length*0.0166 as lengthHours, “hrs.” AS inHours FROM movies where studioname=“Disney” AND y