读书人

怎么指定SQL查询列名

发布时间: 2012-03-19 22:03:05 作者: rapoo

如何指定SQL查询列名
select count(*) from TableName group by FieldName
SQL执行的结果是

(无列名)
后跟N行

现在要将"(无列名)"
指定字串,如"统计值"

how?



[解决办法]
select count(*) as _NUM_ from TableName group by FieldName
or
select count(*) _NUM_ from TableName group by FieldName

读书人网 >C++ Builder

热点推荐