这个SQL语句怎么写啊,大虾!

Question

楼主要这样的吗？？Select teachername,SUM(charge) As Taotal from TableName Group By teachername

Answer 1

teacherName沒有指明對象名select sum(t1.charge) as temp1 ,studentinfo.teacherName as temp2 
from (select distinct ticketId,charge ,teachername from studentinfo )t1 ,subjectinfo where signDate>=startDate and signDate<= endDate and t1.ticketId=studentinfo.ticketId 
group by studentinfo.teacherName

Answer 2

“如果ticketId相同则只求一次”，那只求一次的算哪个teachername的呢？？感觉你的要求和你的例子有区别。

Answer 3

select 
sum(t1.charge) as temp1 ,
studentinfo.teacherName as temp2 
from (select distinct ticketId,charge ,teachername from studentinfo )t1 ,
subjectinfo 
where signDate>= startDate and signDate<= endDate and t1.ticketId=studentinfo.ticketId group by studentinfo.teacherName

Answer 4

select teachername,charge=sum(charge)
from(
select teachername,charge=(
case when teachername=(
select top 1 teachername from studentinfo
where ticketId=a.ticketId)
then charge else 0 end)
from studentinfo a
)a group by teachername

Answer 5

select teachername,sum(charge) as total
from(
select * 
from studentinfo a
where teachername=(select top 1 from studentinfo where ticketid=a.ticketid order by teachername asc)
)t
group by teachername