Partition By divides the result set into partiition and changes how the window function is calculated so in our output for code below we can see Pam Beasley she's female she makes 36000 as a salary ...