SQL Server 数据库设计--SELECT语句

SELECT [DISTINCT] [TOP (n)] { * | select_list }
FROM table_name | view_name
WHERE search_condition
[GROUP BY group_by_expression ]
[HAVING search_condition]
[ORDER BY order_ expression [ASC] | [DESC] ]

SELECT * FROM Student --查询Student表中所有数据

SELECT StudentName, phone, Address, IDENTITYcard FROM Student

SELECT StudentNo, SubjectNo, StudentResult -10 AS Result FROM Result
WHERE StudentResult > 80

SELECT ‘学号:’+ StudentNo + ‘-课程编号:’ + SubjectNo, StudentResult -10 AS ‘成绩’
FROM Result
WHERE StudentResult > 80

SELECT TOP 3 * FROM Result WHERE StudentResult > 80

SELECT TOP 3 * FROM Result --查询结果中返回前 3 行
SELECT TOP 3 PERCENT StudentNo, SubjectNo, StudentResult FROM Result
--查询结果中返回3%的记录

SELECT * FROM Result WHERE StudentResult > 50 AND SubjectNo = 1
--查询结果中分数大于50且课程号位1的人

SELECT * FROM Result WHERE StudentResult > 50 OR SubjectNo = 1
--查询结果中分数大于50或者课程号位1的人

SELECT StudentName, phone, Address, IDENTITYcard
FROM Student WHERE ( StudentName LIKE ‘李%’ OR StudentName LIKE ‘王%’ ) AND Sex =‘女’