Results for "distinct"
6 / 18 posts
Filter by Category
Added columns in a table by dynamic ways
IF OBJECT_ID('AddedDynamicColumn','P') IS NOT NULL BEGIN DROP PROC AddedDynamicColumn END GO CREATE PROCEDURE AddedDynamicColumn AS BEGIN SELECT ED.empid,ED....
drop(), dropDuplicates(), and distinct() in PySpark
🔹 1. drop() – Removing Columns The drop() function is used to remove one or more columns from a DataFrame. 👉 Example: Removing a Single Column from pyspa…
Advance functions in Power BI
ALL Filter: The ALL filter returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied. This function …
Pivoting and Unpivoting Data in SQL
Pivoting Data : Pivoting is the process of converting rows of data into columns, effectively changing the orientation of your data. It's useful when you ha…
SQL Server index Creation by using table
Database performance improve karne ke liye indexes bahut important hote hain. Lekin large ERP ya payroll systems me manually indexes manage karna difficult h...
Pandas for Python Developers: The Complete Guide (Part 1 — Fundamentals)
Meta Description: Master Pandas from scratch. Learn Series, DataFrames, I/O operations, and essential data manipulation with real-world examples. The only gu...