1.列 AS 别名
2.列 别名
3.别名=列
例子:
SELECT ListPrice-StandardCost AS Margin FROM Production.Product
SELECT ListPrice-StandardCost Margin FROM Production.Product
SELECT Margin=ListPrice-StandardCost FROM Production.Product
1.列 AS 别名
2.列 别名
3.别名=列
例子:
SELECT ListPrice-StandardCost AS Margin FROM Production.Product
SELECT ListPrice-StandardCost Margin FROM Production.Product
SELECT Margin=ListPrice-StandardCost FROM Production.Product