>>select * from (select T.Numero, T.Title, T.Url, T.AddDate, row_number() >>over (partition by R.NoThread order by R.NoThread) as Row from Thread T LEFT JOIN Reply R on T.NoThread = R.NoThread where T.NoMember = @NoMember) X >>where Row <=10 >>