一、销售订货数据库
1、SELECT VendName FROM Vendors
2、SELECT productName,Retailprice FROM products
3、SELECT DISTINCT Custstate FROM Customers
二、娱乐数据库
1、SELECT Entcity,EntstageName
FROM Entertainers
ORDER BY Entcity ASC,EntstageName ASC
2、SELECT DISTINCT StartDate FROM Engagements
三、学校日程安排数据库
1、SELECT * FROM Classes
2、SELECT BuildingName,Numberoffloors
FROM Buildings
ORDER BY BuildingName
四、保龄球协会数据库
1、SELECT DISTINCT TourneyLocation
FROM Tournaments
2、SELECT TourneyDate,TourneyLocation
FROM Tournaments
ORDER BY TourneyDate DESC,TourneyLocation ASC
五、食谱数据库
1、SELECT RecipeClassID,RecipeTitle
FROM Recipes
ORDER BY RecipeClassID ASC,RecipeTitle ASC
2、SELECT DISTINCT RecipeClassID
FROM Recipes
《SQL查询凡人入门》学习笔记之一
最新推荐文章于 2022-12-31 17:50:11 发布