官术网_书友最值得收藏!

SELECT

The SELECT clause defines the columns and expressions that will be returned in the results and is the only element that is required to form a valid T-SQL data retrieval statement. Elements in the SELECT statement can be as simple as a single constant value, or as complex as a full T-SQL sub-query, but generally it is a comma-separated list of columns from tables and views in a database.

The following query will return a single row with a single column:

 SELECT 1;

In the following screenshot we can see the result:

The SELECT clause can also be used to format the results by providing column aliases or using expressions to modify the data. Aliases are created with the optional keyword AS, followed by the intended column name to be displayed in the result set:

SELECT Name AS ProductName, LEFT(ProductNumber, 2) AS ProductCode, ISNULL(color, 'No Color') AS Color [...]

Note that, in the results, any row that has a value for Color will display that value, whereas any row that has a null color will display No Color instead:

主站蜘蛛池模板: 安国市| 清丰县| 漳平市| 兴城市| 金川县| 双辽市| 油尖旺区| 琼结县| 含山县| 齐齐哈尔市| 游戏| 龙南县| 长沙县| 旬邑县| 平定县| 静宁县| 商洛市| 湘阴县| 泽州县| 河北省| 台中县| 贡觉县| 原平市| 花莲县| 永昌县| 曲松县| 潼南县| 安达市| 特克斯县| 察隅县| 防城港市| 金川县| 永定县| 宁南县| 昌平区| 英德市| 弥渡县| 东乡族自治县| 兴仁县| 察哈| 吴旗县|