__ Avenger __;

heard. It to the given task has no relation as the HARDWARE forgive 2 persons, without determinancy.

Compare result:

```
IF EXISTS (SELECT 1 FROM sysobjects WHERE name=N'Tabel ' and type ='U ') DROP TABLE Tabel
CREATE TABLE Tabel (
[Person] nvarchar (50);
[Region] nvarchar (30);
[Estimation] int
)
GO
DECLARE
@I int = 10000
BEGIN TRAN
WHILE @I> 0 BEGIN
INSERT Tabel ([the Person], [Region], [the Estimation])
VALUES (N'Name ' +CONVERT (nvarchar (11) ,@I) +N ' Middlename ' +CONVERT (nvarchar (11) ,@I) +
N ' Lastname ' +CONVERT (nvarchar (11) ,@I);
N'Name ' +CONVERT (nvarchar (11), CONVERT (int, RAND ()/0.1*10)), CONVERT (int, RAND ()/0.1*10)
)
SELECT @I = I-1
END
COMMIT TRAN
GO
select top 2 with ties t.*
from Tabel t with (nolock)
order by row_number () over (partition by t. "Region" order by t. "Estimation" asc), 1, 2, 3
SELECT [Region], [Person], [Estimation]
FROM (SELECT *, ROW_NUMBER () OVER (PARTITION BY [Region] ORDER BY [Estimation]) AS N FROM Tabel) Q
WHERE N <3
ORDER BY [Region], [Person], [Estimation]
```