Help Needed to write Query
 

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.

Re: Help Needed to write Query
 

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

Re: Help Needed to write Query
 

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

Re: Help Needed to write Query
 

select count(distinct(EnqSrNo)) from table_name

where QTypeCode=1;

Re: Help Needed to write Query
 

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.

Re: Help Needed to write Query
 

lol, OK, i'll try :P

Re: Help Needed to write Query
 

Thanks :)

Here is the link for my thread.
http://www.daniweb.com/forums/thread113457.html