如题,
可以如下吗:
Select *,count(ID) as allcount from equip where .....
---------------------------------------------------------------
正确回答:
select (select count(*) from equip where 条件1... )as allcount , * from equip where 条件1.......
两个where中的条件应该一致!
如题,
可以如下吗:
Select *,count(ID) as allcount from equip where .....
---------------------------------------------------------------
正确回答:
select (select count(*) from equip where 条件1... )as allcount , * from equip where 条件1.......
两个where中的条件应该一致!