Will try to make this SQL Playlist Massive 😍 How much would you rate yourself in SQL out of 10 ?
@Arjun18820
Жыл бұрын
6
@sscpreparationmadeeasy
Жыл бұрын
7
@Suraj_a_3405
Жыл бұрын
3.but getting confident ..series is pretty helpful..
@ankit8236
Жыл бұрын
8
@pratimadhar9202
Жыл бұрын
6
@anirudhnegi4523
Жыл бұрын
Hi Shashank Great work with the videos. I think the 4th solution is a bit inaccurate since there can be examples such as 'XYZDIAB1' that might be selected in your solution. Here is my solution which I think will work: select * from Patients where conditions like 'DIAB1%' or conditions like '% DIAB1%';
@janaktyagi2720
Жыл бұрын
better solution for third question , without using subqueries: *select distinct salary from employee order by salary desc limit 1 offset 1*
@Suraj_a_3405
Жыл бұрын
Thank you!! please continue this series..very helpful.Thanka again.
@msgupta07
Жыл бұрын
Thank you so much for this playlist
@chitralekhbarve7513
Жыл бұрын
Select Salary as SecondHighestSalary from (select *, rank() over (order by salary) as rnk from employee)x Where rnk = 2 This is also acceptable for second highest salary ?
@Verryvirgo
Жыл бұрын
Great video Shashank 👍 Looking forward for more videos on SQL.
@eldragonrv
Жыл бұрын
Hi Shashank, Thanks for making this video. It was really helpful. Just to point out, for 4th question if you consider %DIAB1% it won't give you the correct answer. It will also consider codes like ABCDIAB12R etc which doesn't represent diabetes 1 as it doesn't start with DIAB1. The right regex is to check both these conditions "%DIAB1%" OR "DIAB1%"
@finestopedia5352
Жыл бұрын
Hi,It will only fetch those conditions whose starting phrase is DIAB1 and ending phrase is DIAB1.It will not fetch conditions like ACNE DIAB100.It will fetch like DIAB100 acute and acute 12DIAB1.
@tomaraditya9487
Жыл бұрын
I am in 2nd year and aiming a data engg internship at CRED. SOLVED ALL THE SQL QUES ON HACKERRANK AND CURRENTLY LEARNING PYTHON ❤️ THIS PLAYLIST WAS MUCH NEEDED...THANKU SIR
@big-bang-movies
Жыл бұрын
sabaas...
@shashankemani1609
Жыл бұрын
Thank you soo much!! This was so helpful.
@shaikusman536
Жыл бұрын
waiting for NXT video....Thanks brother....
@chandrarahul1990
Жыл бұрын
for 2nd ques can we use below query, please let me know whether it is correct or not select ord1.customer_number from orders ord1 inner join orders ord2 on ord1.orders_number = ord2.orders_number-1 and ord1.customer_number = ord2.customer_number
@ajinkyahatolkar294
Жыл бұрын
Quite informative video. I get difficulties while joining more than 2 tables like whether to join A with B and B with C OR a with b and a with c. Can you please explain what is the resultant of those joins ?
@vikashagarwal4305
Жыл бұрын
Basically at first you join two tables..then the resultant of the join is joined with the third table ....then the resultant of the join of 3 tables is joined with the 4th table an so on...in this way the cycle continues
@idigvijayrathod8566
Жыл бұрын
this is best and i think you should continue this
@rushivanjare97
Жыл бұрын
Please try to page in white mode is better to analysis data. Otherwise awesome video
@vivekpuurkayastha1580
Жыл бұрын
Great. But please make different videos for each question.
@360infohub
Жыл бұрын
how much topics should learn in pythone for data science or analysis👍👍👍👍
@surajyadav4816
Жыл бұрын
Simply thank you for the video the way you teach it's awesome.
@ananyaamehra2000
Жыл бұрын
Hello! Your videos are very helpful. Please make a video on Tata Steel TomorrowLab which has both idea and design challenges. Will be very helpful to understand and participate
@360infohub
Жыл бұрын
how much topics should learn in pythone for data science or analysis
@msgupta07
Жыл бұрын
Which website we can use for sql queries for practice?
@nightbot9843
Жыл бұрын
Can you teach normal form it is difficult for me to understand ?
@andhale899
Жыл бұрын
Waiting for your next video in this series
@ThePraveen007007
Жыл бұрын
For Problem 2 - is this query wrong or correct - select customer_number from Orders where order_number=(select max(order_number) from Orders); ????
@janaktyagi2720
Жыл бұрын
Hi brother, this query is wrong because we need to know what is the max count of orders not the max of order , for example if customer_id are like this 2,4,5,6,5.... here customer who orders maximum times is 5. correct query is this ** select customer_number from Orders group by customer_number order by count(order_number) desc limit 1 **
@renukag9030
Жыл бұрын
please make videos on case when in the same way with examples
@pavankumarpk9013
Жыл бұрын
Tried to solve before watching solutions Problem 1 : (Gives me the right output but none of the test cases were passed) select distinct(name) as warehouse_name, sum((w.units*(p.width*p.Length*p.height))) as volume from warehouse w join products p on w.product_id = p.product_id group by name order by name asc Problem 2: (This solution is actually wrong but it worked 😅) select max(customer_number) customer_number from orders Problem 3: (Gives me the right output but none of the test cases were passed) select max(salary) SecondHighestSalary from Employee where salary not in (select max(salary) from Employee) Problem 4 : select patient_id, patient_name, conditions from Patients p where p.conditions like '%DIAB1%'
@pritishpattnaik4674
Жыл бұрын
Hey can u make a all in one video , how to get started with sql leetcode and cover important commands
@rushivanjare97
Жыл бұрын
Which playlist launched
@omkarbelpatre5
Жыл бұрын
Thank you so much sir
@muhammadsalar607
Жыл бұрын
Please solve the hard leetcode tricky questions !👍
@abdullah-khan10
Жыл бұрын
Very excited
@janaktyagi2720
Жыл бұрын
this is even better solution for second Problem without using subqueries:- select customer_number from Orders group by customer_number order by count(order_number) desc limit 1
@ashishkumarsingh3758
Жыл бұрын
Age limit for data science?
@kjvmpandurangarao3536
Жыл бұрын
Need SQL queries for data engineering interview purpose
@maheshsomani43
Жыл бұрын
For the second highest salary we can simply use offset: Select distinct salary from employee order by salary desc Offset 1 fetch next 1 row;
@maheshsomani43
Жыл бұрын
It will help to fetch any salary based on ranks, without using any windows function and Max() function
@360infohub
Жыл бұрын
lot of love to u sir
@prabhakarsharma5556
Жыл бұрын
Bro make video on dsa problem
@longliveindia1637
Жыл бұрын
Shashank bhai sql basic to advance seekhado
@prudhviadari9247
Жыл бұрын
i am the first..........feels great
@harishbadiger4800
Жыл бұрын
For 2nd question select customer_number from (select customer_number,count(order_number) from ORDERS_TABLE group by CUSTOMER_NUMBER having count(order_number)>1) v; this 👆 can also be considered.
@adityavamsi12
3 ай бұрын
select customer_number from orders group by customer_number order by count(*) desc limit 1;
@360infohub
Жыл бұрын
how much topics should learn in pythone for data science or analysis👍👍👍👍
@360infohub
Жыл бұрын
how much topics should learn in pythone for data science or analysis 👍👍👍👍👍👍👍👍
@360infohub
Жыл бұрын
how much topics should learn in pythone for data science or analysis👍👍👍👍
Пікірлер: 70