如何指定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
发布时间: 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