how to get recordno??

[biswa47]

i have table named emp where the coloumns are A AND B. The date in my table emp are A B ---------- 12 0 13 0 0 17 9 0 0 11 0 8 76 0 NOW I want to count the total no of records IN THE TABLE ,no of records (where A !=0 AND B=0 it means value of coloumn A not equal to '0' and value of cpoloumn B equal to zero) AND NO OF RECORDS (where A =0 AND B!=0) thanks in advance

[Joe 2]

Assuming that you are working with Sql Server:

biswa47 wrote:

(where A !=0 AND B=0

The outer query fetches the number of rows in A that are not equal to zero and the inner query fetches the number of rows in B that are equal to Zero.

Select Count(*) [A Not Eq 0],
(Select Count(*) From Emp Where B = 0 ) As [B Eq 0]
From Emp Where A <> 0

The same works the other way around, you'll have to change the operator.

biswa47 wrote:

where A =0 AND B!=0)

Select Count(*) [A Eq 0],
(Select Count(*) From Emp Where B <> 0 ) As [B Not Eq 0]
From Emp Where A = 0

modified on Wednesday, January 16, 2008 10:31:11 AM