SQL Interview Question | How to find departments having only male / female employees?

[@ipsitapanigrahi5004]

The second approach can be used for a lot of complex problems, thank you for discussing this.

[@LearnatKnowstar]

Thank you

[@Shimpivaibhav0922]

HI Maám, I was stuck at one of the complex query, and then i found your this video. The Having clause with SUM has saved my time and worked for me.. thanksss a Lottttttt..... I Really Appreciate you...

[@LearnatKnowstar]

Thanks so much.

[@sravankumar1767]

Superb explanation 👌 👏

[@surajpatil3579]

This sql interview questions playlist is too much helpful..please cover more scenarios

[@LearnatKnowstar]

Thanks so much

[@TheVaibhavdang]

Thanks for the solution.But I have thought it in another way With cte as (Select distinct [DepartmentName],[Gender],dense_rank() over (partition by DepartmentName order by Gender) as rn from [dbo].[DimEmployee]) select Top 2 c.DepartmentName,c.Gender,count(rn) over (partition by c.DepartmentName ) as cnt from cte c order by count(rn) over (partition by c.DepartmentName) What do you think of this solution?

[@rk-ej9ep]

Nice maamm...

[@LearnatKnowstar]

Thank you!

[@hovardlee]

You can also use CTE and then use exists / not exists on CTE.

[@RaviKumar-ub6vy]

Hi Madam, Could you please share the employee table script which you have created .. So that we can practice.. Thank you

[@LearnatKnowstar]

You can find a similar script here. You can modify it a little to suit this scenario. know-star.blogspot.com/2021/02/sql-query-how-to-find-employees-hired.html?m=1

[@dynamicreflections]

Can't we use MINUS operator

[@inhlam5909]

1. Use EXCEPT 2. Use Having condition (aggregation)

[@515jesbinjenet2]

what about Find the department name having maximum female employee