CTE is stand for the common table expression which has result exist only for the when query or procedure run and use the cte result in the main result, cte use for better readability and also use for delete duplicate value using window funtion.