hi,
can u tell me how to write the sql query for this::
my table is like this
cdno software
1 vb
c
c++
2 java
vc++
4 c#
now i want that it will only count the total no of cdno=3
and not 6 i.e where the cdno is blank it does not count that record.my table name is "msoftware"
ishikha
can u tell me how to write the sql query for this::
my table is like this
cdno software
1 vb
c
c++
2 java
vc++
4 c#
now i want that it will only count the total no of cdno=3
and not 6 i.e where the cdno is blank it does not count that record.my table name is "msoftware"
ishikha