Joined August 2015
141 Photos and videos
SQL OFFSET is 0-based, but N (1st, 2nd, 3rd highest) is 1-based Eg: N = 1 → OFFSET = 0 (highest salary) N = 2 → OFFSET = 1 (2nd highest salary) Write a #SQL to find the nth highest distinct salary from the Employee table. If there are less than n distinct salaries, return null
21
Write a #SQL query to report the first name, last name, city, and state of each person in the Person table. If the address of a personId is not present in the Address table, report null instead.
17
#SQL to find second highest salary :
10
Hide the email using python : input='samrlovqryc@gmail.com' output='s*********c@gmail.com'
14
#python code to convert dictionary to tuple using "item()"
12
#python code to convert list to dict using "zip"
10
#PySpark Pivot function :
11
#Pyspark collect_list Function :
8
#Pyspark groupBy Function on 2 columns and using 2 aggregation function : sum and average. #dataengineering #bigdata #pyspark
7
View of Amazon BedRock . Have anyone tried using it ? #amazonbedrock #dataengineering #AIML
14
solitude_key retweeted
19 Jul 2024
25 Oct 2021
Macrohard >> Microsoft
6,272
10,516
147,985
91,888,200
Looks like Microsoft Granted us a Holiday before Weekend 🫣🫣 #MicrosoftOutage #Crowdstrike #microsoft
44
solitude_key retweeted
21 Jun 2024
20,733
105,357
1,239,799
128,663,337
Which Iphone past series is worth buying? Or better to wait for Iphone New model 16 ? #apple #iphone @Apple @iPhoneTeam @iPhone_News @theapplehub @appleinsider
28
Print the different combinations of string on separate lines. #pythonprogramming
17
Print the list of integers from through as a string, without spaces. #Python
18