一个简单SQL语句报错 求解!下班结帖

[happy664618843]

SQL语句如下:

select count(*) as TCount,   LT_PART_COUNT,TS_TID,(TCount*LT_PART_COUNT)  as Total from LI_TICKET,LI_TICKET_SALE where LT_ID=TS_TID and TS_TID='80' group by  LT_PART_COUNT,TS_TID

现在报错TCount无效; 我现在需求想将求出TCount的值乘以LT_PART_COUNT 得出总数 该怎么写呢?

[叶子]

TCount是你新起的别名，当前级别无法使用，将(TCount*LT_PART_COUNT) 中的TCount改成count(*)
---
还有个问题LT_PART_COUNT不在分组字段里面，这个取会报错的。
可以改成max((TCount*LT_PART_COUNT) ),或是sum(TCount*LT_PART_COUNT)

[xuexiaodong2009]

TCount是你新起的别名，当前级别无法使用，将(TCount*LT_PART_COUNT) 中的TCount改成count(*)

[快溜]

select count(*) as TCount,LT_PART_COUNT,TS_TID,(count(*)*LT_PART_COUNT)  as Total 
from LI_TICKET,LI_TICKET_SALE where LT_ID=TS_TID and TS_TID='80' group by  LT_PART_COUNT,TS_TID

[快溜]

你干嘛发重复贴？

[jiao3630]

select count(*) as TCount,LT_PART_COUNT,TS_TID,(count(*)*LT_PART_COUNT)  as Total 
from LI_TICKET,LI_TICKET_SALE where LT_ID=TS_TID and TS_TID='80' group by  LT_PART_COUNT,TS_TID

点快了吧 网卡了