Here is data

EnqSrNo
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
13
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20


QTypeCode
1
1
2
2
2
2
3
3
4
4
4
5
5
5
5
5
5
5
1
1
2
2
2
2
3
3
4
4
4
5
5
5
5
5
5
5
1
1
2
2
2
2
3
3
4
4
4
5
5
5
5
5
5
5
1
1
2
2
2
2
3
3
4
4
4
5
5
5
5
5
5
5
1
1
2
2
2
2
3
3
4
4
4
5
5
5
5
5
5
5

I want Count of EnqSrno where QTypeCode is 1
this is 5 but its showing 10

I tried as -
SELECT DISTINCT COUNT(EnqSrNo) AS COUNT
FROM Table1
WHERE (QTypeCode = 1)

PLz help.

EnqSrNo	QTypeCode
9	1
9	1
9	2
9	2
9	2
9	2
9	3
9	3
9	4
9	4
9	4
9	5
9	5
9	5
9	5
9	5
9	5
9	5
8	1
8	1
8	2
8	2
8	2
8	2
8	3
8	3
8	4
8	4
8	4
8	5
8	5
8	5
8	5
8	5
8	5
8	5
11	1
11	1
11	2
11	2
11	2
11	2
11	3
11	3
11	4
11	4
11	4
11	5
11	5
11	5
11	5
11	5
11	5
11	5
13	1
13	1
13	2
13	2
13	2
13	2
13	3
13	3
13	4
13	4
13	4
13	5
13	5
13	5
13	5
13	5
13	5
13	5
20	1
20	1
20	2
20	2
20	2
20	2
20	3
20	3
20	4
20	4
20	4
20	5
20	5
20	5
20	5
20	5
20	5
20	5

I find them 10 too :-O

Hi Sulley's Boo
Ya they are 10. but only need to count Distinct EnqSrNo against QTypeCode.
Thanks for reply.

select count(distinct(EnqSrNo)) from table_name
where QTypeCode=1;

HI Sulley's Boo
Hey Gr8. Its giving exact result i want. Thanks a lot. :)
Have a nice day.
If you dont mind can u do one more favor. I have posted one moer thread in asp.net. Where i put my Logic but i am unable to get that in code.

Please see if your are Interested.
Thanks a Lot again.......

Have a nice time.

lol, OK, i'll try :P

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.