资 源 简 介
SQL的基本操作---数据的检索篇 什么在查询中对字段命以别名,或重新命名,这样做的原因有两个: ☆所涉及的表的字段名很长,想使字段在结果集中更易处理一些。 ☆创建的查询产生了某些计算或合计列,需要对之进行命名。 不管是什么原因对字段命以别名,在 SQL 中都可以容易地使用 As 子句做得-the basic operation of SQL data retrieval-- What Part of the field inquiries to life alias, or re-naming to do so for two reasons : involved in the table field names is very long, so that the field would result in easier handling. inquiries have created some calculation or together, would be required for the process of naming. Whatever the reason right to life alias field in SQL can be easily done using As CLAUSE