SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS
Vložit
- čas přidán 6. 09. 2024
- In this video, we’ll solve sql queries for practice. Important SQL interview queries.
✨Work related mails can be sent on:
work.sadiasiddiqui@gmail.com
✨If you appreciate my work and would like to donate to support our channel, you can do so here:
paypal.me/sadi...
✨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
1. UPDATE emp
SET salary = salary * 1.05; --This approach is easier to remember.
Right
Concepts explained with such simplicity. Truly awesome.
Query 4,select * from employees where first_name like '%A' and LENGTH(first_name) =6;
Yes thank you!
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. :)
Am beginning to learn SQL, I can't wait to master it.
Same here! Good luck!
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
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 am watch many vedio about SQL in CZcams 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...
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.
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
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)
Awesome voice..
Your videos are life saver! The explanations are easy to understand. Subscribed!
My Exam is there and i was having much doubts in my sql. 😢Thankyou for clarifying my doubts 😊🎉
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
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 👍👍🇮🇹🇮🇹
Learnt SQL topics and queries few days back Just a beginner quite impressed by your q and a
thankyou for the help tomorrow is my offline exam. thanks for making short and conceptual video.
Very useful and helpful videos !!! To the point and time savers !!!
Awesome voice, I guess you must be full time singer
super job .
god bless you.
nice job. In 5 min only i got more information.
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 ♥️
We can also use another method
Select salary +5% as increment from employee
3 question I think we need to use having for aggregate functions
The lecture is great and fine! But I remember my ex after hearing your voice....lol...😄
Hi sister,
Thanks for your videos..it helped me to land SQL developer job..
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
Very Well Explained, and a nice practice for my learning.
Simple sample of sql queries with simple pen and awesome musical voice.. 💐
Thank you so much, this 5 min video idea is very helpful
Thank youu😊
I have watched many video for SQL tutorials but I understand ur video properly thanks for the help
The video is excellent. A small improvement; it's not an alphabet. It is a letter. Alphabet means A to Z.
Hello, i hope u r dng well ,good job and plz post some a little complex queries..
select first_name from employees where first_name like '%A' and length(first_name) = 6
WHAT AVERY NICE AND CLEAR PRESENTETION KEEP IT UP!!!!!!!
I have been looking for such vedios for long. Short ,simple and easy.
Thank you so much for all the efforts you are making to provide this information smoothly .
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
Explained in simple and beautiful way. Thanks
Thank you. I love that you do it on papaer. That's my way of getting in everything.
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😌❤
As a database admin i approve that i use some of these simple queries almost everyday lol
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
It can be simply done as set income= income*1.05;
Voice is so cute 🤩
in this video if you show the table also, then it becomes very easy to understand for beginners
please give us some lecture on How to get odd and even number from the given table, thank you so much
1. Select sal,sal+5/100 from emp;
Aapki writing meri tarha hai :D
Good content and explanation btw.
I am a working professional.
These situation based queries are a great way to learn faster , please make a Long video or comple your other in one...thanks
In question 3 group by clause is necessary to use but don't use
Concepts explained with such simplicity & sweet voice
You have missed percentage sign in 4 ques. It's just a correction. Your vidios are well explained.😊
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
Clean,Simple and precisely explained :) . Good work.
To the point !!!🔥🔥
Last but not least is emp ''salary'' very imp '''Q'''
Creative explanation. Another way of Quick Learn SQL. Keep Going 👍👍👍
Nice explanation.very helpful.easily understanding.
Great work and explanation Sadia feels like a friend of mine is teaching me 👍🏻👍🏻
Update Query for the first question updates the database table permanently, instead you can create conditional column.
Assuming there are 3 columns in employee table. (ID, NAME , SALARY)
SELECT ID, NAME, 1.05*SALARY AS SALARY
FROM EMPLOYEE;
Thank you a lot for your efforts , and greeting from Morocco 🇲🇦❤
Good tutorial. Please keep making these beautiful Tutorials.
Thank you so much 👍🏻. It was a great brief coverage of DML statements.
excellent miss, and im sure about to follow your all videos and please keep going on.....
I have one question in question no:- 4 '_ _ _ _ _A' in this case where we write '%'
if we use '%A' there might be names with n number of alphabets ending with A. The question asked only a 6 alphabet name ending with A.SO it is _____A
In First question we have to add NVL function
Amazing explanation easy to understand tq u for making easy👍🏻👌🏻👏
My answer is income=income*1.05 just to keep the math simpler.
yup
Thanks mam for explaining it in a simple manner.
Voice is really amazing.❤️
I have got a table name Programmer with columns... Name, Language known 1, Language Known2, Salary.
Need to know the Programmer Name with highest salary in each language...So suppose Name is Anand he knows Language 1.. C. Language 2 ..Oracle salary is 3000...2and employee is Ajeet Knows Language 1 Cobol...Language 2 C and so on so forth....
- Select Salary from programmer
Will give you salaries of all programmers in the table just salaries not in any specific order if you want them in order
- Select Salary from programmer order by desc
This gives salaries in descending order
Sissy it's just amazing and usefull.
Absolutely brilliant. I would like to see more query.
I have one doubt in 3rd question :
One of the video you said that having clause need to use with aggregate function .
Where is used to filter the rows
If the select has another field other than coun(*) then the query will have GROUP BY ... HAVING COUNT(*) (condition).
Ex:
SELECT COUNT(*), DEPARTMENT_NAME
FROM EMPLOYEES
GROUP BY DEPARTMENT_NAME
HAVING COUNT(*) > 1;
Thankyou Mam ....This helped me a lot...
I know all these queries
But I just recollect those commands
Anyways thank you...
Very clean & No lag in Explanation
Good
Keep it up...
UPDATE Employees
SET Salary = Salary * 1.05 ; ( Increase salary by 5%)
Nice explanation......TQ for sharing the knowledge
Nice video, voice is very low, could you please increase your mic voice from next time.
Thanks for your SQL query explanation sister 👍
Perfect and easy to understand 👌
I like the way you teach.
I have one confusion?
structure of the table is retained in Truncate or in delete?
Thanks a lot for all of your videos..helped me a lot. Best wishes to you. And keep making videos.
Hi,
This is the table called comments_and_translations
id comment translation
1 very good
2 good
3 bad
4 ordinary
5 cdcdcdcd very bad
6 excellent
7 ababab not satisfied
8 satisfied
9 aabbaabb extraordinary
10 ccddccbb medium
The output should be
comment
very good
good
bad
ordinary
very bad
excellent
not satisfied
satisfied
extraordinary
medium
please help me out with the query.
Hi i really like the way you solved the queries
.As of now i get ol the solution of this video.. Could you please taught me personally for my interview..
Thank you so much ...please make more videos on SQL interview questions
In the scenario of count its an aggregation's term soo we have to use having instead of where
No need actually!
Very concise and explicit
Question why would not use LIKE again for the third problem. I see you use equal, but I can understand if the preference, would the LIKE still work for finding ‘ABC’?
For 4 th question, the first-name of the employees starting with A is asked ....if we want to select first-name or the whole thing..?
Sorry ending with A
The voice 😍
In third query shouldn't we have 'HAVING' instead of 'WHERE' clause, as count is an aggregate function?
Yes it is aggregate function but she is not using it on count, she is putting a condition with where clause.
Having is use to filter data from groups.
Example-
Select count(employee), state from employees where department = 'abc'
Group by state
Having count(employee)> 10
@@TheRahulbisht1989 Thanks Brother for clearing my confusion 🤝
such a nice quick video , tq so much
Nice explanation with a beautiful voice
mesmerizing voice and to the point video
Make more video on java programming question...