Lec-62: SQL Queries and Subqueries (part-4) | Having clause | Database Management System

Sir i think we should write count* along with dept too

Can we use = instead of in in this query?

How do i get the maximum employees from the group by Dept; ....please can anyone help me??😢😢

Can we replace In with =?

Ur * the best * teacher sir

HOW TO JOIN 2 TABLES AND FETCH DATA FROM BOTH AND GET THE HIGHEST TWO USING GROUP BY?

SELECT employee_name, department_name
FROM employee
GROUP BY department_name, employee_name
HAVING COUNT(*) > 2;
why we aren't using this?

Nice g

Lov it thx u

Today 2023 , July completed 4 yr of this video , but your energy , is fresh,
😅
You are a best student friendly teacher

Thanks arigato

Awesome sir thank you🙏

Vese to be very honest agar gate ke liye prep kara hota to apse hi kata paid course kharid ke

Full playlist please 🥺🥺🥺

why not equals to instea of IN?

Couldnt it be just like: Select E_name, Dept, from Emp Group by Dept Having Count (*) < 2

Nice

Sir isse phle vale me aapne count * q liya tha

Can we use dept = instead of dept In?

sir has a good collection of T-shirts🙃

if we use dept = except dept in, is it ok?

Sir can I use dept= instead of dept In

we can also write like select dept , count(*) as count_emp from employee group by dept heving count_emp<2;

Sir mene video pause krke apne se ek query banayi h
select dept from (select dept, count(*) as c from emp group by dept) where c < 2;
Ye query sahi h kya??

Thank you sir❤

Your Query is correct BUT leading in incorrect way as question was get dept name where EMP ARE LESS THAN 1..So you should have used e_name/e_id in group by cause..it would have given more justice to question

Thanks sir

Sir what about this query
Select dept, count(*) from emp group by dept having count(*) <2;

Thankuuh sir ✨

In Inner Query, why don't we take select dept, count(dept) ...... as took it in the last video.

Thank you so much Varun sir
1.Gate + 2.Infosys training aapka material hi use kr rha hu
🙏🙏🙏

Sir where are your legs , i want to touch them

Superb explanation

Fantastic. Brilliant

You r great sir .. pls dont say thanks at the end as we must be thankful to u for these wonderful videos to improve our databases skills... A big thanks to u🙏🙏

nice

Amazing teacher

Yes brst teacher

Or bhi videos bnain sir..cluses ki

Break Records one day.

Sir very nice explanation 💕

hello sir thank u for this video
select e_name , dept from emp group by dept
having COUNT(dept) < 2;
aise b chalega na sir

Sir you make everything crystal clear...i watched the videos of some other creators they are already confused what to teach

amazing

Aree sir thanks a lot, I tried other videos too but only this channel was also to help

Can u pls tell me how much sql required for power bi developer role... Pls

can the query could be, select dept from emp where count(dept) <2 group by dept ;

Wonderful. Even non-technical background can understand.