question about sql query

Question

0.00/5 (No votes)

See more:

hello i have one query
I have one table programer and its fields are
pname
proficiancy1 and
proficiancy2

and i want the data from this table that
count the number of prohramer whose proficeancy1 = c or proficiancy2=c

I fire the count query in that but on saprare column and retrive 2 different count but i want only one count as output how to do?

Posted 29-Sep-13 8:38am

An@mik@

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Accepted Answer · 2013-09-29T08:51:00

Solution 1

How about using a where clause?

SQL

SELECT COUNT(p.pname)
FROM programmer as p
WHERE  
    p.proficiancy1 = c OR p.proficiancy1 = c

Since I have no clue from the little that your question contained I can not really say what c is supposed to be since you didn't take care to tell us what type the "proficiency" fields are made of. BTW, you also forgot to tell us the kind of RDBMS you are using. Your tag "ASP.net" doesn't really help either.

Regards,

— Manfred

Posted 29-Sep-13 8:51am

Manfred Rudolf Bihy

Comments

An@mik@ 29-Sep-13 15:04pm

ok i forgot to tell but i solve that problem . thank you: :-)

Manfred Rudolf Bihy 29-Sep-13 15:15pm

Interesting, your question was posted 34 minutes ago and my response was posted 21 minutes ago.
For the sake of all other enquirers you might want to modify your question to show what you did to achieve your goal.
Thank you!