1 Comment

  1. Rajesh

    what is the difference when we are using Row_Number() and Rank() both with Partition by field as both returing the same result..?

    select ROW_NUMBER() over(partition by Name order by EID) ,EID ,Name from Employee

    select RANK() over(partition by Name order by EID),EID ,Name from Employee


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>