how to count group by data on two union table

achikeziey

Expand|Select|Wrap|Line Numbers

 select mobile ,count(id) from

(select  mobile ,id from phone_1204 where astatus='newsub' and left(service,4)='euro'

union all

select mobile,id from phone_1205 where astatus='newsub' and left(service,4)='euro' )

 group by mobile

are this the right code

India777

Try with @@ROWCOUNT.This Returns the number of Rows affected by the Sql Query.Please Study this link to know abount @@ROWCOUNT.
http://technet.microsoft.com/en-us/l.../ms187316.aspx and http://msdn.microsoft.com/en-us/library/ms188774.aspx.

Example:

Expand|Select|Wrap|Line Numbers

 
select @@rowcount as count, mobile ,count(id) from

(select mobile ,id from phone_1204 where astatus='newsub' and left(service,4)='euro'

union all

select mobile,id from phone_1205 where astatus='newsub' and left(service,4)='euro' )

group by mobile

Rabbit

Please use code tags when posting code.

If you run it, you will know if it's correct or not.

how to count group by data on two union table

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ