can someone plz Query

Hi

Thanks and regards 

Please refer https://www.sqlservertutorial.net/sql-server-window-functions/sql-server-rank-function/

You can try using Rank, Partition and Order by 

Hi,

 

Please find this link which will help you, first find length of table row then you will get total numbers of row tehn find which row you want,

https://stackoverflow.com/questions/34948229/jquery-find-the-last-and-before-last-row-in-a-table