you can try below this query :
SELECT OrderId, TaskID, MAX(SerialNo)SerialNo
FROM table_name
GROUP BY OrderId, TaskId
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/