Delete duplicate Rows in SQL
11:27
11 ай бұрын
SQL Group by assignment
11:32
Жыл бұрын
Common Mistakes In SQL
8:43
Жыл бұрын
Identity Membership Operators
6:18
Пікірлер
@AdiS-p2x
@AdiS-p2x 2 күн бұрын
Virtual box is not installing please help
@mogamboo
@mogamboo 4 күн бұрын
Bhai mera windows 8 laptop he or isme virtual box install nahi ho raha....plz reply
@Cric.info-Editor
@Cric.info-Editor 5 күн бұрын
Only MySQL and PLSQL is enough to get a fresher job ?
@CodingGlitz
@CodingGlitz 5 күн бұрын
Honestly no. Now a days people expect more from a fresher.
@Cric.info-Editor
@Cric.info-Editor 5 күн бұрын
​@@CodingGlitzSir plsql devloper ke liye ar kya sikhna hoga NBFCS ya Banking Sector mai job ke liye
@CodingGlitz
@CodingGlitz 5 күн бұрын
For PLSQL role specific I think it's enough to have SQL and PL SQL knowledge.
@Cric.info-Editor
@Cric.info-Editor 5 күн бұрын
@@CodingGlitz Thanks a lot sir 🙏
@radheybhaiya515
@radheybhaiya515 5 күн бұрын
Sir workbance mai rollback kyu nhi ho raha
@ektabagde2880
@ektabagde2880 8 күн бұрын
output 2 colums me kyu ata hai or konsa assume krna hai?
@CodingGlitz
@CodingGlitz 8 күн бұрын
kzbin.info/www/bejne/n6S0aaimYt-Ihrs Please watch this I hope you will understand JOINS completely.
@ektabagde2880
@ektabagde2880 7 күн бұрын
@@CodingGlitz Thanks got the concept now
@adityamulay1342
@adityamulay1342 10 күн бұрын
simple method for finding nth highest salary is: select distinct col from table order by col limit 1 offset n-1;
@ektabagde2880
@ektabagde2880 10 күн бұрын
muze samjhne me roblem ho rhi hai
@shantahiremath7313
@shantahiremath7313 12 күн бұрын
Thank you, easily understandable explanation.
@CodingGlitz
@CodingGlitz 8 күн бұрын
Glad it was helpful!
@ShashLashkare
@ShashLashkare 12 күн бұрын
Good
@ChinnaDornadula
@ChinnaDornadula 12 күн бұрын
❤❤❤❤❤
@jitb0310
@jitb0310 14 күн бұрын
very nice sir 🙏🙏
@Adilnawazkhan7509
@Adilnawazkhan7509 14 күн бұрын
Correct video
@akshaydamke6237
@akshaydamke6237 16 күн бұрын
alter is alsocoming in tcl
@CodingGlitz
@CodingGlitz 16 күн бұрын
Not at all
@sksuman3810
@sksuman3810 17 күн бұрын
Best explanation ever ❤
@sitampatel9047
@sitampatel9047 18 күн бұрын
Best explanation Sir , Thank you
@ansilaameer606
@ansilaameer606 18 күн бұрын
Thanks to the core
@anandamoymukherjee1756
@anandamoymukherjee1756 20 күн бұрын
Best video
@kumaraman3695
@kumaraman3695 20 күн бұрын
hi ,i have a query,if two employees have same salary within same department it will show both records right,in this case windows function is showing only one out of the two.
@kangkanbarman7777
@kangkanbarman7777 21 күн бұрын
Teaching style is good but the last table (library) isnt working in my management tool .... I AM using postgresql ....
@ansilaameer606
@ansilaameer606 23 күн бұрын
Thank you so much. ❤
@akashmeherishi1589
@akashmeherishi1589 23 күн бұрын
526.9 kyo aaya 526.8 kyo nhi?
@RVEE295
@RVEE295 25 күн бұрын
Perfect explanation
@gayatrimamidwar8364
@gayatrimamidwar8364 26 күн бұрын
Very very informative. Thanks a lot sir😊
@SpaceWonders5
@SpaceWonders5 26 күн бұрын
you are a gem to sql community
@CodingGlitz
@CodingGlitz 26 күн бұрын
Thanks for such kind words 🙏
@HARSHRAJ-gp6ve
@HARSHRAJ-gp6ve 26 күн бұрын
sircan you provide the desired outcome of each query question?
@Ketan_ram
@Ketan_ram 28 күн бұрын
Your very good teacher ❤❤🎉🎉
@ankitpurshottam3442
@ankitpurshottam3442 29 күн бұрын
select sal from emp as e where 1=( select count(distinct(sal)) from emp as h where e.sal<=h.sal ) more efficient for any salary. Thanks A Lot Sir.
@jyothisudeep8624
@jyothisudeep8624 Ай бұрын
could not find the ddl and dml for dulplicate table ..can you give that in description.
@summysanny
@summysanny Ай бұрын
Kya wahita info di hai.... Isse badiya ye bata deta ki Earth is round
@CodingGlitz
@CodingGlitz Ай бұрын
Next video me wo v bata denge 😎
@amiransari4070
@amiransari4070 Ай бұрын
Ubuntu install nhi ho gaya lekin select krne k liye ubuntu ka option nhi aa raha
@hrishi2839
@hrishi2839 Ай бұрын
I am rewatching playlist again and skipped this part @7:25 then I struggled a lot
@SHOURYASINGHAI-h8v
@SHOURYASINGHAI-h8v Ай бұрын
IN THE LAST QUERY why i can;t write , select * from emp where sal > AVG(SAL) ??
@ARUSHISINGH-n1k
@ARUSHISINGH-n1k Ай бұрын
This is my first time i watched your video. I was struggling since long for a good sql channel.THank you so much sir.
@CodingGlitz
@CodingGlitz Ай бұрын
Glad you liked it 😊.
@TheOne-cy3yu
@TheOne-cy3yu Ай бұрын
Setup pe click krne k baad. ek terminal open hoke band ho rha he within a flash.. Fir koi installation ka option nhi aa rha h.. Help please
@CodingGlitz
@CodingGlitz Ай бұрын
If it's not working you can practice online as well. kzbin.info/www/bejne/iWeyimBtn9tgea8
@TheOne-cy3yu
@TheOne-cy3yu Ай бұрын
How to create a db and tables to practice sql ?
@CodingGlitz
@CodingGlitz Ай бұрын
kzbin.info/www/bejne/aIOvqnqXbsmlbqM
@ironman6698
@ironman6698 Ай бұрын
You always rock man🤟🏻 Your explanation is awesome❤
@CodingGlitz
@CodingGlitz Ай бұрын
Thanks 🙏
@ironman6698
@ironman6698 Ай бұрын
Your content is always awesome 💯 Will you please bring question-ans series of leetcode
@hrishi2839
@hrishi2839 Ай бұрын
I m facing issue while executing the procedure, output dont come
@hrishi2839
@hrishi2839 Ай бұрын
Ok issue is fixed, repeating playlist again...
@ironman6698
@ironman6698 Ай бұрын
Now no doubts are remain in my head about window functions💯 Thanx to explain in great way.. Will you please share the ans of query which is in end
@ironman6698
@ironman6698 Ай бұрын
Your way of explanation is best💯
@hrishi2839
@hrishi2839 Ай бұрын
Thank u, this was so much informative.
@hrishi2839
@hrishi2839 Ай бұрын
Alternate way: declare i number:= 1; a number:= 5; begin loop exit when i>10; dbms_output.put_line('5'||'*'||i||'='||a*i); i:=i+1; end loop; end;
@hrishi2839
@hrishi2839 Ай бұрын
Thanks
@hrishi2839
@hrishi2839 Ай бұрын
Thanks
@SHUBHAMJADHAV-lo5kb
@SHUBHAMJADHAV-lo5kb Ай бұрын
Very informative ❤
@ironman6698
@ironman6698 Ай бұрын
Your videos are awesome and they definitely help freshers like me💯so please bring more content on sql concepts
@SyedDanishHusain-n7j
@SyedDanishHusain-n7j Ай бұрын
73/100
@ironman6698
@ironman6698 Ай бұрын
Sir plz bring more videos like this They are being very useful to freshers like me💯
@firozsayyed3180
@firozsayyed3180 Ай бұрын
Thank you sir, It's nice explanation ❤👍👍
@Roky-ru2wz
@Roky-ru2wz Ай бұрын
Sir linus ke keval 9 hi video hai kya