0

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.

2
Contributors
6
Replies
7
Views
9 Years
Discussion Span
Last Post by sbv
0
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

0

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

0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.