MySQL to Laravel Query

Level 55

@eyantra what you are trying to do?

Level 6

group By of the sub query which is also result of group By

Level 55

@eyantra you query looks overcomplicated. show your table and and expected result

Level 6

i have team member details table, which contains id | team_id | name .... 1 | 1001 | 2 | 1001 | 3 | 1002 | 4 | 1002 | 5 | 1002 |

Now select count(*) number_of_members from team_detail group by team_id gives me how many members in the team.

and select a.members, count() as teams from(SELECT count() as members FROM team_detail group by team_id) as a group by a.members

gives me the team number with number of members.

members | teams 2 | 1 3 | 1

vandan

Level 13

@eyantra

try this

DB::table("team_member_detail ) as a")
	->select("a.members", "count () as teams from(select count() as members")
	->groupBy("team_id")
	->get();

Level 6

Unknown column 'a.members'

Level 55

@eyantra I still do not understand your idea, so I can suggest to wrap it entirely in query

dd(DB::select('your entire query'));

Level 6

Yes, this i have already tried using DB::raw, not working.

Anyway i resolved this issue using laravel collection: countBy

Thank you !!

Level 55

@eyantra not DB::raw, DB::select

dd(DB::select('select a.members, count() as teams from(SELECT count() as members FROM team_detail group by team_id) as a group by a.members'));