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 Country (
 Name_Country VARCHAR(25)
)
INSERT INTO Country
VALUES
('USA'),
('ENGLAND'),
('ITALY'),
('GERMANY'),
('FRANCE')
5 rows affected

SELECT TOP(4) Name_Country FROM Country


Name_Country


USA

ENGLAND

ITALY

GERMANY


SELECT 
         MAX(CASE WHEN a.rn = 1 THEN a.Name_Country END) AS NAME_1,
         MAX(CASE WHEN a.rn = 2 THEN a.Name_Country END) AS NAME_2,
         MAX(CASE WHEN a.rn = 3 THEN a.Name_Country END) AS NAME_3,
         MAX(CASE WHEN a.rn = 4 THEN a.Name_Country END) AS NAME_4
    FROM (SELECT b.Name_Country,
                 ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS rn
            FROM Country b) a


NAME_1
NAME_2
NAME_3
NAME_4


USA
ENGLAND
ITALY
GERMANY


Warning: Null value is eliminated by an aggregate or other SET operation.