DENSE_RANK

First_value & Last_Value according to group set is that easy ? tip #44

  Problem:-  Most of the time we require data in which we require first value and last value from different group of rows. Now how easy we can get result this is one of the challenge for us. Solution:- Lets understand this by an example. Suppose you have a sales table in which you maintain …