SQL | Find employees with salary greater than department average / and less than company average
Рет қаралды 18,837
Күн бұрынThis video is part of the series of videos on SQL Queries on Employee Salary database
How to find employees with salary greater than the average salary of department
How to find employees with salary greater than the average salary of department but less than the organizational average
Check out all the SQL Queries and KZfaq videos for this series here -
know-star.blog...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org
@LearnatKnowstar Жыл бұрын
Sorry for the audio issue with this video. Similar queries with practice data are covered in one of our new videos here. Please check it out - kzfaq.info/get/bejne/e8Vmm8R2xJeUlXk.html
@Sanjay-gz2wj 3 жыл бұрын
Nice explanation
@kristyowens2284 3 жыл бұрын
very useful. Thanks.
@LearnatKnowstar 3 жыл бұрын
Thank you
@hv0032113 3 жыл бұрын
Great explanation
@LearnatKnowstar 3 жыл бұрын
Thank you
@aakashvaish3757 Жыл бұрын
Can you please share the data table script. As it is helpful for the practice.
@LearnatKnowstar Жыл бұрын
Sorry for the audio quality in this video. Similar query is covered in one of our new tutorials here - kzfaq.info/get/bejne/e8Vmm8R2xJeUlXk.html This has the link to sample data and associated queries. Hope it helps 🙏
@mezomezo8718 Жыл бұрын
Can u plz tell me if the join condition was just to join the two tables or does it have anything to do with the query question. I understand the statement after the on join condition but not understanding the on join caluse itself
@aslamqureshi9234 2 жыл бұрын
it is helpful but not audible and thanx for solution
@Sanjay-gz2wj 3 жыл бұрын
Not audible
@rohitjaiswal8116 Жыл бұрын
Sound problem... Voice is very low
@sumitdantale3145 2 жыл бұрын
Could you please re upload this video with better audio?
@LearnatKnowstar 2 жыл бұрын
Yes, we will be updating the entire series again. Thanks.
@parantikaghosh4396 3 жыл бұрын
solution is helpful but not audible
@sm.prithiv7174 Жыл бұрын
Worst
Learn at Knowstar
Рет қаралды 10 М.
Learn at Knowstar
Рет қаралды 9 М.
Harley Quinn with the Joker
Рет қаралды 25 МЛН
Learn at Knowstar
Рет қаралды 48 М.
CodeEra
Рет қаралды 104 М.
Learn at Knowstar
Рет қаралды 30 М.
techTFQ
Рет қаралды 502 М.
Learn at Knowstar
Рет қаралды 160 М.
Learn at Knowstar
Рет қаралды 95 М.