SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) 
	Apr 11 2022 16:24:07 
	Copyright (C) 2019 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE table1 (
[date] DATE,  
[group] VARCHAR(1),
code INT,
pol INT,
relation INT  
);

INSERT INTO table1
VALUES
(GETDATE(), 'A', 11, 1, 1),
(GETDATE(),'A', 11, 2, 2),
(GETDATE(),'A', 12, 1, 1),
(GETDATE(),'A', 12, 2, 2),
(GETDATE(),'A', 12, 3, 3),
(GETDATE(),'A', 12, 4, 4),
(GETDATE(),'B', 11, 1, 1),
(GETDATE(),'B', 11, 2, 2),
(GETDATE(),'B', 11, 3, 3),
(GETDATE(),'C', 11, 1, 1);

SELECT * FROM table1;


date
group
code
pol
relation


2022-11-10
A
11
1
1

2022-11-10
A
11
2
2

2022-11-10
A
12
1
1

2022-11-10
A
12
2
2

2022-11-10
A
12
3
3

2022-11-10
A
12
4
4

2022-11-10
B
11
1
1

2022-11-10
B
11
2
2

2022-11-10
B
11
3
3

2022-11-10
C
11
1
1


SELECT TOP 26 
  [date]
  ,[group]
  ,[code]
  ,[pol]
  ,[relation]
FROM table1 WHERE [group] in ('A','B','C','Z') and code = '11'


date
group
code
pol
relation


2022-11-10
A
11
1
1

2022-11-10
A
11
2
2

2022-11-10
B
11
1
1

2022-11-10
B
11
2
2

2022-11-10
B
11
3
3

2022-11-10
C
11
1
1


;WITH cte AS
(
   SELECT *,
         ROW_NUMBER() OVER (PARTITION BY [group], code ORDER BY code ASC) AS rn
   FROM table1
)
SELECT *
FROM cte
WHERE rn = 1 AND code = 11


date
group
code
pol
relation
rn


2022-11-10
A
11
1
1
1

2022-11-10
B
11
1
1
1

2022-11-10
C
11
1
1
1

date	group	code	pol	relation
2022-11-10	A	11	1	1
2022-11-10	A	11	2	2
2022-11-10	A	12	1	1
2022-11-10	A	12	2	2
2022-11-10	A	12	3	3
2022-11-10	A	12	4	4
2022-11-10	B	11	1	1
2022-11-10	B	11	2	2
2022-11-10	B	11	3	3
2022-11-10	C	11	1	1