1.FIRSTVALUE : Returns first value based on partition and order by clause 2.LASTVALUE : Returns last value based on partition and order by clause