✨Link to my SQL e-book: imojo.in/rkajq9 ✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)
It feels like when a friend of urs is explaining all this to you just before 5mins and boom you rock that exam.... Explanation with such an ease..... Woww....
Hi Ma'am, Your videos are really helpful for interview preparation. Now we need not to waste precious time browsing confusing contents on net. Keep uploading more contents. :)
I am watch many vedio about SQL in TH-cam but I have not get man think about SQL Query question solving in easy way but after watching your vedio every think clear about SQL and I think you have too much knowledge about SQL Query and thanks for providing this type of think by the help of vedio...
Give more questions like this. It is helpful when we practice this Looking at your questions at one place. If I don't practice sql for 3 4 days, i forget basics of SQL like insert, update, delete drop with where etc
I do not believe so. When you put the wildcard at the beginning, the logic would tell me to expand on the number of starting characters. Test it! I did and the author is correct with the simplest solution.
Hi, in your third query, i remember somewhere in your other video you mentioned, if an 'aggregate function' is used, we can't use 'WHERE' clause rather 'HAVING' clause is to be used, however you have used COUNT with WHERE, kindly enlighten me, Thanks in advance
Thanks for helping me.. Tomorrow is my offline practical exam, i am searching for this from morning i cant but in this video i was cleared about it.. Thanks a lot.. And by the way your voice is so sweet😌❤
You explain in that way like if anyone didn't know about SQL then also he can understand and get the idea about what is happening and how the queries are written👌👌 thank-you soo much
hi i have a table like this Name 01-Feb 02-Feb 03-Feb 04-Feb 05-Feb shyam 2.46 -0.13 -0.27 1.20 -2.64 mohan -1.35 -1.82 0.46 1.84 1.81 ram 3.76 4.35 1.39 -0.68 -3.45 rina -0.45 8.09 1.95 0.78 -1.30 ashok 0.53 -2.62 4.84 -0.51 0.00 faizal 1.45 2.36 3.07 4.90 7.74 aarti 2.20 -1.08 -1.09 1.10 -3.26 AARON -3.36 4.00 -2.74 0.21 0.10 jagdish 0.66 0.03 1.29 0.41 -1.79 these are the marks of test happened on these dates. i want to know which student performance is increasing day by day. i want query in sql pls help me regards, sunil
![[LIVE] : ONE ลุมพินี 88 | คู่เอก "ป้อมเพชร vs อัสลามจอน"](http://i.ytimg.com/vi/1ZqTVVbMgbo/mqdefault.jpg)
✨Link to my SQL e-book: imojo.in/rkajq9
✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)
It feels like when a friend of urs is explaining all this to you just before 5mins and boom you rock that exam.... Explanation with such an ease..... Woww....
simp spotted
XD
Exactly
Query 4,select * from employees where first_name like '%A' and LENGTH(first_name) =6;
Yes thank you!
Concepts explained with such simplicity. Truly awesome.
1. UPDATE emp
SET salary = salary * 1.05; --This approach is easier to remember.
Right
Hi Ma'am,
Your videos are really helpful for interview preparation. Now we need not to waste precious time browsing confusing contents on net. Keep uploading more contents. :)
I'm watching after 4 years , still it is so helpfull and i will always be helpfull in/for future ❤❤
I like the way she explains the problems and very good way to explain on papers by writing them self
Am beginning to learn SQL, I can't wait to master it.
Same here! Good luck!
I am watch many vedio about SQL in TH-cam but I have not get man think about SQL Query question solving in easy way but after watching your vedio every think clear about SQL and I think you have too much knowledge about SQL Query and thanks for providing this type of think by the help of vedio...
Give more questions like this.
It is helpful when we practice this Looking at your questions at one place.
If I don't practice sql for 3 4 days, i forget basics of SQL like insert, update, delete drop with where etc
3 question I think we need to use having for aggregate functions
Your videos are life saver! The explanations are easy to understand. Subscribed!
4th one - select *from employees where firstname like '%A' and len(Firstname)=6
I think this should also work
Yes, as long as you're using the right reserved words like "length" vs "len". I think of "len" when using almost all other languages.
Awesome voice..
Very useful and helpful videos !!! To the point and time savers !!!
super job .
god bless you.
nice job. In 5 min only i got more information.
For query 4, it is meant to be SELECT * FROM employees WHERE first_name like '%_____a';
Yes
I do not believe so. When you put the wildcard at the beginning, the logic would tell me to expand on the number of starting characters. Test it! I did and the author is correct with the simplest solution.
Why they are not using* in 1&2?
SQL compilation error: error line 2 at position 6 invalid identifier 'first_name'
SELECT *
FROM emp
WHERE first_name LIKE '_____A'; THIS IS FINAL AND CORRECT. ( 5 underscores)
Learnt SQL topics and queries few days back Just a beginner quite impressed by your q and a
WHAT AVERY NICE AND CLEAR PRESENTETION KEEP IT UP!!!!!!!
For the first one update employers set income = income * 1,05 is easier
Anyway good job
yes. thnkss. hi r u italian
@@ab-lz2gh yes
@@smarter_solutions 👍👍🇮🇹🇮🇹
Explained in simple and beautiful way. Thanks
I have been looking for such vedios for long. Short ,simple and easy.
My Exam is there and i was having much doubts in my sql. 😢Thankyou for clarifying my doubts 😊🎉
Voice is so cute 🤩
Thank you. I love that you do it on papaer. That's my way of getting in everything.
Simple sample of sql queries with simple pen and awesome musical voice.. 💐
Very Well Explained, and a nice practice for my learning.
Awesome voice, I guess you must be full time singer
Hi sister,
Thanks for your videos..it helped me to land SQL developer job..
We can also use another method
Select salary +5% as increment from employee
I have watched many video for SQL tutorials but I understand ur video properly thanks for the help
Would be good to include the questions/Queries in your description summary so that we can also practice once without having to run the video again
thankyou for the help tomorrow is my offline exam. thanks for making short and conceptual video.
Nice explanation.very helpful.easily understanding.
Howww she is explaining over paper. To be honest it's more understandable than most of the channel who is on PC. Loved your channel ♥️
select first_name from employees where first_name like '%A' and length(first_name) = 6
Thank you so much, this 5 min video idea is very helpful
Thank youu😊
1. Select sal,sal+5/100 from emp;
I am fresher.. tomorrow is my interview 😂😂but I don't anything about sql😢.. but this video is helpful ❤
To the point !!!🔥🔥
Concepts explained with such simplicity & sweet voice
It can be simply done as set income= income*1.05;
Good tutorial. Please keep making these beautiful Tutorials.
i have exam tomorrow 😂
😂I have an exam in 5hrs😊
@@cgimotion3351 hey ! How was your exam ? I have mine soon
@@sah_eli aced it,
I have exam in 15 mins
I have in 0 minutes
Nice explanation......TQ for sharing the knowledge
Thank you. So beautifully explained.
Clean,Simple and precisely explained :) . Good work.
Sissy it's just amazing and usefull.
Creative explanation. Another way of Quick Learn SQL. Keep Going 👍👍👍
Hello, i hope u r dng well ,good job and plz post some a little complex queries..
Thank you so much for all the efforts you are making to provide this information smoothly .
The voice 😍
in this video if you show the table also, then it becomes very easy to understand for beginners
What is the difference between `SELECT * FROM employees where first_name LIKE 'ABC';` and `SELECT * FROM employees where first_name = 'ABC';`?
Both are same bro
Hi, in your third query, i remember somewhere in your other video you mentioned, if an 'aggregate function' is used, we can't use 'WHERE' clause rather 'HAVING' clause is to be used, however you have used COUNT with WHERE, kindly enlighten me, Thanks in advance
Please watch my latest video on WHERE VS HAVING IN SQL
you’ll understand it properly
The video is excellent. A small improvement; it's not an alphabet. It is a letter. Alphabet means A to Z.
excellent miss, and im sure about to follow your all videos and please keep going on.....
Thanks for your SQL query explanation sister 👍
Amazing explanation easy to understand tq u for making easy👍🏻👌🏻👏
Very concise and explicit
Thank you a lot for your efforts , and greeting from Morocco 🇲🇦❤
Thanks for helping me.. Tomorrow is my offline practical exam, i am searching for this from morning i cant but in this video i was cleared about it.. Thanks a lot.. And by the way your voice is so sweet😌❤
Bhut acha pda rhe ho mam. Thnku.
Absolutely brilliant. I would like to see more query.
Well explained sis 👏👏👏
Nice explanation with a beautiful voice
Thanks mam for explaining it in a simple manner.
Thankyou Mam ....This helped me a lot...
The lecture is great and fine! But I remember my ex after hearing your voice....lol...😄
Aapki writing meri tarha hai :D
Good content and explanation btw.
I am a working professional.
Very well explained .... thank you mam ...
As a database admin i approve that i use some of these simple queries almost everyday lol
Thank you so much 👍🏻. It was a great brief coverage of DML statements.
Great work and explanation Sadia feels like a friend of mine is teaching me 👍🏻👍🏻
awesome teaching skills
My answer is income=income*1.05 just to keep the math simpler.
yup
mesmerizing voice and to the point video
Wow she is mind blowing 👌
These situation based queries are a great way to learn faster , please make a Long video or comple your other in one...thanks
You explain in that way like if anyone didn't know about SQL then also he can understand and get the idea about what is happening and how the queries are written👌👌 thank-you soo much
Perfect and easy to understand 👌
Last but not least is emp ''salary'' very imp '''Q'''
In First question we have to add NVL function
Great explanation thank you!!
Voice is really amazing.❤️
Voice is pleasant
hi
i have a table like this
Name 01-Feb 02-Feb 03-Feb 04-Feb 05-Feb
shyam 2.46 -0.13 -0.27 1.20 -2.64
mohan -1.35 -1.82 0.46 1.84 1.81
ram 3.76 4.35 1.39 -0.68 -3.45
rina -0.45 8.09 1.95 0.78 -1.30
ashok 0.53 -2.62 4.84 -0.51 0.00
faizal 1.45 2.36 3.07 4.90 7.74
aarti 2.20 -1.08 -1.09 1.10 -3.26
AARON -3.36 4.00 -2.74 0.21 0.10
jagdish 0.66 0.03 1.29 0.41 -1.79
these are the marks of test happened on these dates.
i want to know which student performance is increasing day by day.
i want query in sql
pls help me
regards,
sunil
Very good saadhiya
Thank you..Easy way to understand 😊
In question 3 group by clause is necessary to use but don't use
You have missed percentage sign in 4 ques. It's just a correction. Your vidios are well explained.😊
such a nice quick video , tq so much
Nice explanation 👏, your new Subscriber 🎉
Great explanation with beautiful voice
Thanks a lot for all of your videos..helped me a lot. Best wishes to you. And keep making videos.
This is awesome bless you Kid
Very nice explanation 👌
precise explanation
please give us some lecture on How to get odd and even number from the given table, thank you so much