如何获得总条数?
有一个sql语句:
select a.AccountCode,a.AccountName, count(1)as Ammount,o.ObjectCode from RSITEM i inner join RSACCOUNT a on i.AccountID=a.AccountID
inner join RSOBJECT o on i.ObjectID=o.ObjectID inner join RSLOCATION l on i.LocationID=l.LocationID where l.LocationCode like 'BJ01%' group by o.ObjectCode,a.AccountCode,a.AccountName
但我想获得查询结果的总条数,如何写呢?多谢!