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
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.
Hide the email using python :
input='[email protected]'
output='s*********[email protected]'
#Pyspark groupBy Function on 2 columns and using 2 aggregation function : sum and average.
#dataengineering #bigdata #pyspark
Looks like Microsoft Granted us a Holiday before Weekend 🫣🫣
#MicrosoftOutage #Crowdstrike #microsoft
Which Iphone past series is worth buying?
Or better to wait for Iphone New model 16 ?
#apple #iphone @Apple @iPhoneTeam @iPhone_News @theapplehub @appleinsider
Print the different combinations of string on separate lines.
#pythonprogramming
Print the list of integers from through as a string, without spaces.
#Python



















