select b.id,b.name,c.address,a.type
from tableA as a,tableB as b,table C as c
where a.id=b.typeid and b.addid=c.id
group by b.id,b.name,c.address,a.type
执行以上sql语句,查询出的结果如有8条记录,那么我怎样在 sql 语句中实现,将这个结果数(8)表示出来。我只想查询出满足这个条件的总的记录的条数。谢谢回答!
最佳答案
0
select count(*) from (select b.id,b.name,c.address,a.type from tableA as a,tableB as b,table C as c where a.id=b.typeid and b.addid=c.id group by b.id,b.name,c.address,a.type) temp
收获园豆:
10
这个是正解! 谢谢。