In a subquery, we don't have to maintain order
Added a fix such that order is considered when there is a limit clause.