PinnedJayakrishna SurampudiinTowards DevFinding duplicates in Snowflake and removing them using temporary table and swap with command.Create a table named customers and insert some data into it and we will try to check duplicates from the customers table.Apr 12Apr 12
PinnedJayakrishna SurampudiinTowards DevLoading kaggle csv dataset into Snowflake named internal stage.check below kaggle dataset link to download a sample dataset.Apr 4Apr 4
PinnedJayakrishna SurampudiReturn the latest data in Pysparkconsider the following dataframeJan 9Jan 9
PinnedJayakrishna SurampudiHandling data with multiple delimiters in Pyspark.Consider a DataFrame which reads data from a csv file and display it using show() method.Jan 6Jan 6
PinnedJayakrishna Surampudidifferent modes in Pysparkπ£π²πΏπΊπΆπππΆππ²: - This is the default mode of reading a dataframe. - If spark in unable to parse a data type due to a mismatch whileβ¦Jan 5Jan 5
Jayakrishna SurampudiinTowards DevRemoving duplicates using row_number() in Snowflake.1)Create a table NameTable and insert data into it.5d ago5d ago
Jayakrishna SurampudiFinding second highest salary in Snowflake.Finding second highest salary using max() function.5d ago5d ago
Jayakrishna SurampudiinTowards DevFinding months based on timestamp using months_between() method in Snowflake.we had months_diff column which we got past months6d ago6d ago
Jayakrishna SurampudiinTowards DevTo find the top 5 selling products at the store level in the past 30 days in Snowflake.Step 1) Create a table transactions in snowflake.May 18May 18
Jayakrishna SurampudiinTowards DevSQL Query: Calculating Running Total of Salaries by GenderComparing rows vs range inside over() clause in sqlMay 11May 11