Sql Problem,how can one more name show with the Count value

Question

0.00/5 (No votes)

See more:

hi,

this is my Sql Query.it's working fine and Out put is correct below show

SQL

select   COUNT(*) from tbl_Job_OrgOpeningDetail org
inner join tbl_job_Functional_Area fa on org.Role_type=fa.Funcational_id
where org.Role_type in (21,15) Group by  org.Role_type

out put

SQL

Column Name
2
3

but i Want Name of Functional Name show with the COunt Values

I am try this

SQL

select   COUNT(*),fa.FuncationalArea from tbl_Job_OrgOpeningDetail org
inner join tbl_job_Functional_Area fa on org.Role_type=fa.Funcational_id
where org.Role_type in (21,15) Group by  org.Role_type

But error system show
like this :-

Quote:
Msg 8120, Level 16, State 1, Procedure sp_job_ddlBindings, Line 48
Column 'tbl_job_Functional_Area.FuncationalArea' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

how can do remove this error..
Thanks

Happy Problem ☻

Posted 22-Dec-13 19:49pm

joginder-banger

Add a Solution

Comments

Seema.Net 23-Dec-13 1:59am

if u want to show fa.FuncationalArea put this with Group By
select COUNT(*),fa.FuncationalArea from tbl_Job_OrgOpeningDetail org
inner join tbl_job_Functional_Area fa on org.Role_type=fa.Funcational_id
where org.Role_type in (21,15) Group by org.Role_type,fa.FuncationalArea

OR

select COUNT(*),COUNT(fa.FuncationalArea) from tbl_Job_OrgOpeningDetail org
inner join tbl_job_Functional_Area fa on org.Role_type=fa.Funcational_id
where org.Role_type in (21,15) Group by org.Role_type

joginder-banger 23-Dec-13 2:58am

Thanks sir

2 solutions

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)

TrushnaK · Accepted Answer · 2013-12-22T20:32:00

Solution 2

Try this query:-

SQL

select   COUNT(*),fa.FuncationalArea from tbl_Job_OrgOpeningDetail org
inner join tbl_job_Functional_Area fa
on org.Role_type=fa.Funcational_id
where org.Role_type in (21,15) Group by  org.Role_type,fa.FuncationalArea

Posted 22-Dec-13 20:32pm

TrushnaK

Comments

joginder-banger 23-Dec-13 2:57am

Thanks buddy..,...

TrushnaK 23-Dec-13 3:18am

welcome.

josephbhaskar · Accepted Answer · 2013-12-22T19:56:00

Solution 1

Add fa.FuncationalArea in group by clause. Your query should look like this

SQL

select   COUNT(*),fa.FuncationalArea from tbl_Job_OrgOpeningDetail org
inner join tbl_job_Functional_Area fa on org.Role_type=fa.Funcational_id
where org.Role_type in (21,15) Group by  org.Role_type, fa.FuncationalArea

Posted 22-Dec-13 19:56pm

josephbhaskar

Comments

joginder-banger 23-Dec-13 2:58am

Thanks Buddy

josephbhaskar 23-Dec-13 3:31am

welcome.. let me know if u face any other issues