ROW_NUMBER(), LAG() and MERGE are the three most powerful operators I use in SQL that are out of the average Joe's knowledge. They are simple to learn yet extre

ROW_NUMBER(), LAG() and MERGE are the three most powerful operators I use in SQL that are out of the average Joe's knowledge. They are simple to learn yet extremely useful. Also, after 25 years in the IT business I still can't write a proper PIVOT clause without googling it first. Shame on me. (btw I'm a MSSQL nerd. Been in Oracle/ODI world for a couple of years but it was too scary)