SQL-简单查询

最新推荐文章于 2024-07-14 00:13:14 发布

weixin_30550081

最新推荐文章于 2024-07-14 00:13:14 发布

阅读量131

点赞数

原文链接：http://www.cnblogs.com/LifeDecidesHappiness/p/9328649.html

版权

/*
    人员：LDH
    功能：SQL-简单查询
    日期：2018-7-18
 */

USE TSQLFundamentals2008;
GO

-- Select some columns' information.
SELECT empid,
    lastname,
    firstname,
    address,
    city,
    country
FROM HR.Employees;

-- GROUP BY
SELECT '国家' = country,
    COUNT(1) AS '员工个数'
FROM HR.Employees
GROUP BY country;

-- Expression
SELECT '订单日期' = orderdate,
    YEAR(orderdate) AS '订单年份'
FROM Sales.Orders;