SQL Query

[Krish Khan]

Hello everyone..

I am poor in writing sql queries so i need help...


in my table i have two columns like: team and result_code
team is simple name of different teams, whereas in result_code i have repetation of four types of values like rpc, tpc,npc and sis

Now i need to display team and its relative count of 'rpc' that each team has...

[Bear Bibeault]

Please take the time to choose the correct forum for your posts. This forum is for questions on Swing. For more information, please read this.

This post has been moved to a more appropriate forum.

[Pawan Komaram]

select team, count(result_code) as reputation where result_code = 'rpc' group by team;

[Pawan Komaram]

select team, count(result_code) as reputation from mytable where result_code = 'rpc' group by team;

[Krish Khan]

not just for rpc but i need to get count for tpc too which is in same column.