GREAT EXPLANATION SIR IN WHOLE KZbin DATABASE TUTORIALS I FEEL COMFORT WITH YOUR TUTORIALS ONLY STAY BLESSED LIKE SAME FROM PAKISTAN..
@Dhirendrakumar-dk1dt2 жыл бұрын
Make it very easy to understand SQL. I have watched your all series of SQL and that helps me a lot to crack my interview, thank you very much sir for sharing your information ❤️
@nickbaib18395 жыл бұрын
Thank you so much! Continue the good job my friend! Greetings from Greece!
@GateSmashers5 жыл бұрын
wow..Thank you for your support..
@kushagrasahu82894 жыл бұрын
Your channel made SQL learning easy informative and fun🙌. I literally binge watched sql series.
@annoniimous Жыл бұрын
Alternate Answer for finding nth highest salary: SELECT Salary FROM employee ORDER BY Salary Desc limit 1 offset 0 Here, limit means : how many output values you want to show on the screen () offset means: let assume you want to show nth (4th) highest salary . In this case you will provide offset 3 which means you are leaving top 3 rows and you are choosing the 4th one . (( "offset means escaping the number of rows from top"))
@ajaysingh-kd4nt Жыл бұрын
limit does not work with oracle sql select * from (select * from employee order by salare desc) where rownum
@sr7821 Жыл бұрын
@@ajaysingh-kd4nt your code selects highest salary not Nth. I think this should work: select * from (select * from (select * from employee order by salary desc) where rownum
@ajaysingh-kd4nt Жыл бұрын
yea i was working on highest salary only @@sr7821
@ajaysingh-kd4nt Жыл бұрын
yes that might work filtering the Nth tuples and then getting the record @@sr7821
@AMANPATEL-g8v Жыл бұрын
mnnit wle bhi aa rhe kyaa , biotech me kb se dbms aa gya bhai ??
@ayeshaameen39032 жыл бұрын
Wowwww You are a genius. No one have ever taught me like this.. thank you so much for this one specially.
@varshasingh27485 жыл бұрын
Aapka lecture dekhe bina din achha ni jata your enthusiastic way of teaching fill Josh.
@vinitakeer5154 жыл бұрын
Thank you sir jb ap bolte hai k ye meri garrenti hai that puch line is superb.... God bless you
@ishangujarathi10 Жыл бұрын
One of the frequently asked question in interviews and placement/internships tests, thank you so such a perfect and easy explanation!!!
@ayushyadav41803 жыл бұрын
i think in this world there would be no teacher other than him who don't need his students to know the language he is talking in i have seen comment of ppl from all over the world appreciating him.
@ranjeetpatra92124 жыл бұрын
The way you elucidate this complex thing is really appreciable. Hats off ❤️
@bhuppidhamii Жыл бұрын
how does he explains every topic in a clear and comprehensible manner.😭💖
@OmitA255 жыл бұрын
Wow sir....its a great thing to have you on youtube....very informative video....thanku so much....
@MrAmmugadu5 жыл бұрын
Thank you so much sir, before I watched your video I was totally frustrated mind, bcoz I unable to understand subqueries,but after watching your vedio really I got more analysis points on subqueries, thank you again sir
@gotamkartik213 жыл бұрын
thanks buddy, now i can understand this concept better.
@souviknag2 жыл бұрын
I'm watching it very late. And there's only one thing that's going on in my mind, ITS BETTER LATE THAN NEVER!! I'm so glad that I found this channel after all. Subscribed!!
@yuvrajoberoi78344 жыл бұрын
No one has helped me more learning SQL queries than you sir.
@bharadwaj003mydreams4 жыл бұрын
It's true
@nivi64145 жыл бұрын
Thanks a lot sir!. Been looking for the perfect explanation for months. Thanks again!
@NishaOnYoutube4 жыл бұрын
Sir the way you teach and explain is beyond amazing...because of you I got golden badge in hackerrank....
@anitha66613 жыл бұрын
Thank you so much for this video. I was struggling to understand the logic behind this and you just cleared all my doubts!!! : )
@krishna99712 жыл бұрын
Thank you sir, i was searching this concept from long ago, finally understood the working from your video only. Thank you for making sql easy.
@sushantsinha82162 жыл бұрын
best channel ever over youtube for understanding sql tutorial
@rounak32395 жыл бұрын
Gurujee shandar jabardast zindabaad
@hudachanna4918 Жыл бұрын
You are amazing. Finally I understand how this works
@vivekgupta50413 жыл бұрын
No need of costly books !!! Much more matter than that provided by books !!!
@ShivamSharma-xk1yp2 жыл бұрын
Right
@nitin90422 жыл бұрын
Average netpack at 200 can get you knowledge worth milli6
@ayushnegi51234 ай бұрын
😢@@ShivamSharma-xk1yp
@rahulmungali7810 Жыл бұрын
One of the best video available in internet for correlated query👍👍
@avishgoswami21414 жыл бұрын
Man you nailed it...Hats off to you!!!
@drawingloverswithsohana61943 жыл бұрын
I like your all vedio and always watch your vedio when I fetch trouble to solve CSE DEPARTMENT related problem.
@rishabhsen92223 жыл бұрын
I have a doubt... Inner query me to condition ye hai ki ' e2.salary > e1.salary '... To pehle e2 ki salary 10,000 ka comparison e1 ki salary k sath hoga to first comparison me to answer 0 hi ayega kyoki 10,000 e2 ki kic bhi salary se bda nhi hai... Jbki sir ne ulta comparison krke pehle comparison me answer 4 nikal diya... Sir ne ' e1.salary
@PythonisLove3 жыл бұрын
you cant believe, I can solve most dbms questions already after taking notes from your videos...I have never read a book
@zabilmaooz77803 жыл бұрын
same here
@kedandu42094 жыл бұрын
Well explained . I highly appreciate your talent and logic.
@avtarchandra24072 жыл бұрын
abb samjh me aya sirr ki Nth salary ku famous question hai ...kuki isme pura basic database grind ho jata hai ...love your effort
@shadabsiddiqui282 жыл бұрын
sir apki jinti tareef ki jaye kam hai you are great
@BEKKAMBHARATHASIMHAREDDY Жыл бұрын
BEST EXPLAINATION EVER AND EVER SIR THANK YOU SO MUCH 🥰🥰🥰🥰
@Ammuworld_himaja3 жыл бұрын
Thankyou very much, this is much helpful. Now i understood why that N-1 concept works just with the COUNT.
@kritisk14 жыл бұрын
Thanks a ton, one of the best video which clearly explains the concept and logic behind the query.Im from Tamil Nadu but I was able to follow the language without any trouble because of the explanation
@chanchalarya9832 жыл бұрын
THIS IS CALL GENIOUS WAY TO RIGHT QUERY
@aayush54743 жыл бұрын
Take Away: Inorder to find Nth highest salary the salary should have N-1 salaries which are greater than given salary
@aashishgoyal14362 жыл бұрын
quite helpful comment.
@nishu21662 жыл бұрын
Excellent sir.... Really logic is very imp and that is clear... 👌👌💐
@ravi69963 жыл бұрын
We can use LIMIT, OFFSET for yielding same results in case of finding nth highest
@ravikumar-wj3rr3 жыл бұрын
you are great sir very best way to teach thank you sir
@kunalsingh57945 жыл бұрын
Sir please also upload videos on digital electronic... ....... Please make video on sequential circuit....🙏🙏🙏🙏
@AayushJain-mr6bx4 жыл бұрын
Great playlist for DBMS. Very well explained. Kudos.
@GateSmashers4 жыл бұрын
Glad it was helpful!
@fatimaiqra21692 жыл бұрын
Mny b try kiya bilkul thik ans aya ...best explanation sir
@jovitalobo1273 Жыл бұрын
you explained this complex theory in awesome way. hats off to your efforts
@01kumarr2 жыл бұрын
Superb much better than a book
@LV-ni6tf3 жыл бұрын
Urs explaining way really super....
@LV-ni6tf3 жыл бұрын
@lunatic7923 жыл бұрын
Bhai behre insaan ko bhi samjha sakte hein, thank u so much.
@jayasreecarey78432 жыл бұрын
Thanks ! Nice Explanation :)
@yasmeenkarachiwala96125 жыл бұрын
Thank you so much Sir! Clear, concise teaching, making sure the fundamentals are understood ! Greetings from San Francisco!
@GateSmashers5 жыл бұрын
thank you so much..its a great feeling that people from US appreciate my work. Thank you for your love and support..bless you
@shashanksharma77473 жыл бұрын
very good explanation underrated channel deserve more subscribers
@kumarsaheb Жыл бұрын
best explanation ever.. God Bless !!
@shrikrushnakarkhele9122 Жыл бұрын
superb info sir
@deepa81772 жыл бұрын
thanku for explaining each line got so much crystal clarity..
@deekshakhan45062 жыл бұрын
such a nice concept i got from u sir🥰
@Poorna100883 жыл бұрын
Your explanation is awesome bro
@neelesh6213 жыл бұрын
Was seraching this..thnk u sir for this awesome level explanantion!!
@ankitbaiskhiyar31062 жыл бұрын
select max(salary) from Employee e1 where N-1 = (select count(distinct salary) from Employee e2 where e2.slaray > e1.salary (Leetcode)
@pavangsk8404 Жыл бұрын
kutha bhi dhekega tho samaj lega sir thank you so much... wonderful explanation
@sagarbhavsar77742 жыл бұрын
very useful
@pawan81543 жыл бұрын
really appreciable...
@pradyutpanja53132 жыл бұрын
Thanks sir , last day in my interview 2nd highest salary was asked to me .my answer was right like....SELECT MAX(salary) FROM employee WHERE salary < (SELECT MAX(salary) FROM employee).. but i had a huge confusion on like how to find out the other cases 4th ,5th etc. but all confusions are totally cleared now. Thanks a lot sir.. now i have decided to watch your all videos related to SQL. and also i will recomend this to others who are actually facing on sql. such a nice tutorials...
@smrutiranjanparida97662 жыл бұрын
see no one answering while everyone busy praising channel,
@m.tayyab8712 жыл бұрын
really found quality content...
@sakijilan79083 жыл бұрын
I have to say Sir ji, You are simply the BEST!!
@anujgrewal44564 жыл бұрын
Very nice way Sir .......today i cleared this way ........
@md.anisurrahman17233 жыл бұрын
Nice explanation, to speak the truth.
@harshjilka3 жыл бұрын
Compiler confuse ho jayega : ye kya bat bani 😎🔥😂 OP
@iCyrus3 жыл бұрын
😅🤣
@santoshsomu Жыл бұрын
thank you bro, i was able to understand easily with your detailed and examples explanation, thank you !
@pradeepkumar-qu1gc Жыл бұрын
Very nice explanation friend. thanks a lot
@neelkanthbk4 жыл бұрын
Thank you so much, for explaining it such simplicity!!! You made it so easy to understand!!
@AyurshiK2 жыл бұрын
great work sir beautifully explained difficult topics. it helped me a lot.
@shubhamsood14063 жыл бұрын
Another approach for MySQL users, also worked on duplicates salaries SELECT * from Employee WHERE salary= (SELECT DISTINCT salary from Employee ORDER BY salary DESC LIMIT N-1, 1);
@sanyogsalve62563 жыл бұрын
Thanks buddy it's easily understood
@sayalikawle42732 жыл бұрын
your query is not firing giving errors
@geetbawa9903 жыл бұрын
Excellent.... God bless u sir
@shreengul64883 жыл бұрын
Greetings from Pakistan! I have no words to describe how good you explain every concept sir. Keep it up👍🏻
@waqaskhan21653 жыл бұрын
Yay log na hotay to hum pakistanion ka kia huta hahaha
@karanmalkhede66892 жыл бұрын
@@waqaskhan2165 hihi pakistan ka bhi ek yt hai mohammd naam se wo bhi mast sikhate sql .maine ek 2 topic unse hi sikhe hai
@entrtnmnthub53574 жыл бұрын
sir ur teaching is jst WOW!!
@surajkolekar79443 жыл бұрын
select a_id,salary from agg as a1 where 3 = (select count(distinct(salary)) from agg as a2 where a2.salary > a1.salary); agg is table name.. Thnk u for simplification.............
@VickySharma-rz7he2 жыл бұрын
Great Explanation Sir thanks for such work
@misunadiyan5 жыл бұрын
Great personality
@metalank103 жыл бұрын
Better understanding after watching this.
@subhenduchsingh49814 жыл бұрын
Really Appreciate ... Have understood the concert 👍👍
@ashvinimeshram52423 жыл бұрын
Thanks sir. This is very helpful. Now I am able to write quaries.🙏🙏🙏🙏
@avaniagarwal89734 жыл бұрын
Really amazing explanation!!!
@Subha_life3 күн бұрын
Great work sir ❤
@shekharsalunke2263 жыл бұрын
Hi Sir, Thanksgiving your knowledge.. this method is too good.. 👍
@narenderreddyvanga89082 жыл бұрын
Excellent Explanation..👌
@shreyashachoudhary4802 жыл бұрын
Simply amazing. Thanks.
@sandhyajain74724 жыл бұрын
Sir can you dive in a little more and explain why we did E2.salary > E1.salary not the other way around. Thanks for all the explanation that does not go over my head.
@rasheedmohammed31233 жыл бұрын
Awesome...I loved the way he explained the solution...even experienced DB developers can't explain it.
@suyash7450 Жыл бұрын
yOU make it very easy to understand......
@hireinnag29393 жыл бұрын
Great video. Very much explanatory!
@mohammadrizwan37792 жыл бұрын
Sir your video is excellent no 1 do one more thing if you give example on sql server management studio that would be much better than board.
@mohammadruhulamin5991 Жыл бұрын
You are Awesome Sir !
@nehadubey71923 жыл бұрын
Nice..thanku for guidance
@garvitvijay11052 жыл бұрын
Absolute savior
@pruthvirajjadhav40495 жыл бұрын
This logic is such that how many kids are elder than this child if there two child greater than this one then he is third . how to find the the second last child ? Q . how to find the second minimum salary ? ANS : try to get this . select salary ,id from emp e1 where n-1 = (select salary count (distinct salary) from emp e2 where e2.salary
@sonalpal93323 жыл бұрын
This question asked in interview also. Thanks a lot buddy
@sajansekhu87855 жыл бұрын
thnkk u so much ji...great efforts...keep it up...Stay blessed..
@renukarani73923 жыл бұрын
Great explanation
@meetpatel3580 Жыл бұрын
Good Explanation sir👀
@manjusri92832 ай бұрын
Thank you bro thank you very much.... its very useful