thank u for explaining,,,Can some please explain below Table1 Table2 inner join left join right full join cross join Sample1 52 Sample1 52 1 5 7 9 10 49 Sample2 53 Sample21 53 0 Sample1 48 Sample11 48 1 Sample3 48 Sample22 70 1 Sample4 52 Sample3 48 0 Sample5 54 Sample41 52 1 Sample5 20 Sample5 54 1 SQL query for full join is showing 11 records and I see NULL values.. NOT sure why Name age Sample1 52 Sample2 53 Sample1 48 Sample3 48 Sample4 52 Sample5 54 Sample5 20 NULL NULL NULL NULL NULL NULL NULL NULL
@thulasinagaraj671510 күн бұрын
Wow
@ssunitech68904 күн бұрын
Thanks 🙏
@ervhart277613 күн бұрын
God bless you for this amazing playlist. Thank you very much.
@Kouravvines16 күн бұрын
What if i want to define only 2 column not all the columns then what i can do?
@madhusudhanreddyt283818 күн бұрын
this is vert static code.. we can use the dynamic code like... Order MonthNoNew = IF(Orders[Order MonthNumber] > 6, Orders[Order MonthNumber] - 6, Orders[Order MonthNumber] + 6)
@barmalini19 күн бұрын
Thank you sir, this is very useful. I did not quite understand the purpose of joining a dataframe with itself, this part: df1.alias('a').join(df1.alias('b') Could someone explain?
@rajakumaranr299812 күн бұрын
To find the MgrName. if you see the Note: MgrId is EmpId of employee, In that case Mgrname would be EmpId of Empname. for eg : MgrId is 100 mean then MgrName would be "raj"
@sushmaahire127520 күн бұрын
Thank you
@ssunitech689020 күн бұрын
Thanks 👍
@vaibhavdalvi857020 күн бұрын
Awsm approach to teach
@ssunitech689020 күн бұрын
Thanks 😊
@demodemo123-g6o22 күн бұрын
Hi bro good playlist kindly upload more challenging and solvable sql questions in this playlist. if you couldnot find time, plz upload it in a single video thanks for your efforts
@anuragawadhiya400323 күн бұрын
This should be Part-29
@ssunitech689023 күн бұрын
Right 👍
@grim_rreaperr24 күн бұрын
dbutils.widgets.text("nth_salary", "1") windowSpec = Window.partitionBy(F.col("Deptname")).orderBy(F.col("Salary").desc()) result_df = df.withColumn("salary_rnk", F.dense_rank().over(windowSpec)) nth_val= int(dbutils.widgets.get("nth_salary")) highest_rnk= result_df.agg(F.max("salary_rnk").alias("max_val")).collect()[0][0] if nth_val <= highest_rnk: result_df.filter(F.col("salary_rnk") == int(dbutils.widgets.get("nth_salary"))).drop("salary_rnk").display() else: print(f"This value is out of Bounds. We are expecting rank values less than or equal to {highest_rnk}.")
@pramodhgeorge429225 күн бұрын
very helpful. thanks a lot!
@ssunitech689024 күн бұрын
Glad it helped ☺️
@ThaoNguyenThiPhuong-q3x25 күн бұрын
can you teach how to do the page 2 of this dataset, i mean the dashboard at page 2 on your power bi
@divyasri538326 күн бұрын
We can do it without alter row right? Without alter row ,It will give the same output
@aqshatagade69326 күн бұрын
Can we use web activity instead of webhook? Also, do we need to use same account for teams and ADF in this scenario?
@meme_Overflow26 күн бұрын
bhai @oggysworls5205 ne jo queery puchi hai na wo batao mera bhi same issue hai
@USA_to_Asia_in_202429 күн бұрын
Thank you for this video. Very helpful.
@ssunitech689029 күн бұрын
Thanks 👍
@USA_to_Asia_in_2024Ай бұрын
Thank you.
@ssunitech689029 күн бұрын
Thanks 👍
@adityakardile5062Ай бұрын
Can't we use append variable activity to get the name of the fine in for loop rather using another get metadata activity?
First of all, nice video Second, should the timestamp be hard coded everytime? How to make the time stamp dynamic??
@harshareddy8264Ай бұрын
Why r we calling testing folder as archive folder?
@vijay.s-ll1yqАй бұрын
with cte as (Select * From Adm_Education union Select * From Adm_Sports union Select * From Adm_behaviour), cte_2 as (select Student_id,education_marks,case when education_marks <=70 then 'Fail' when education_marks >70 and education_marks<=80 then 'Pass' when education_marks >80 then 'Merit' end as marks_status from cte), cte_3 as (select Student_id,marks_status,count(2) as cnt from cte_2 group by Student_id,marks_status ), cte_4 as (select *,row_number() over(partition by student_id order by cnt desc) rn from cte_3) select Student_id,marks_status from cte_4 where rn =1
not works for even row numbers. it should take the average of the middle ones for even row numbers.
@azkarathore4355Ай бұрын
Can we get GPU A100 from gcp on free account
@munisekharbhupathi7183Ай бұрын
We have supplier's in legend and count of late pos in values. 90% late suppliers need to show with their name and remaining 10% should come in others category. How to do this.pls help.
@sammail96Ай бұрын
Alternate approach is to use regexpreplace. replaces space more than one with ','. then apply split function. then iterate over array to get column values. split(regexReplace(Column_1,`[ ]{2,}`,','),',')[1], split(regexReplace(Column_1,`[ ]{2,}`,','),',')[2], so on...
@ssunitech6890Ай бұрын
Thanks for sharing 🙏
@sammail96Ай бұрын
We can do this very easily with logic app
@ssunitech6890Ай бұрын
Yes
@anonymous20638Ай бұрын
I am working in Persistent Systems since very long time. They are not showing any leniency to even very old employees. I was on bench for two months and I received a call from HR for termination, but I got saved luckily as I got assigned to the project on the same day. In past Persistent was known as very employee friendly company but now as they are growing they are becoming worse.
@ssunitech6890Ай бұрын
Say Thanks to God, and start searching for other opportunities. It's a really bad company.
@anonymous20638Ай бұрын
@@ssunitech6890 During the great resignation boom period of 2021-22, the CEO was crying and requesting employees who had resigned to take back their resignation. He was giving big gyan like we didn't remove single employee during Covid, What goes up comes down, etc etc. At that time We were getting emails every week to refer candidates saying that they will loose projects if they don't get the candidates. And now see how they have changed colors!!! Sab Gyan baju main dal diya and now removing employees left-right and center. Forced resignations are still continuing.
@ElvinVarghese-vv1roАй бұрын
hey, when i try debit card , its getting rejected
@ssunitech6890Ай бұрын
Please enter correct information because it should work.
@iliashterev38Ай бұрын
I think Q 5 should be wrong. UPDATE @TBL SET ID=NAME,NAME=ID Once you set the ID column to have value of the NAME then the value of ID itself should be lost. Which means both columns now should have the NAME value. Could you please help me (and other) on that. Thank you.
@ssunitech6890Ай бұрын
In same query, you can replace it.
@iliashterev38Ай бұрын
@@ssunitech6890 I am sorry. I did not understand. Could you please try once more ?? I noticed one major error in my initial post. Instead of "of" I had written "if". Thank you.
@krishnasaikollaАй бұрын
can you please help me on 'error message the requested operation requires elevation'
@VinodKumar-gz8bkАй бұрын
Sir, make video of pyspark Architecture please?
@ssunitech6890Ай бұрын
Sure
@user-ht4bl8fm1tАй бұрын
Its a good project and Nice idea.
@ssunitech6890Ай бұрын
Thanks 😊
@BalaMurugan-kb8riАй бұрын
----> 1 df1=df.select(spark_partition_id().alias('partid')).groupBy('partid').count() NameError: name 'spark_partition_id' is not defined Sir I am getting above error
@MubbashirAthharАй бұрын
hi, thanks for the video presented. I just want to know how we can reduce the PIE size (Circle). because when we make that Pie Visual some label gets hidden.