Greetings, Select Participants from table will result in Participants ------- John Nancy Jem Albert Smith Daniella I want a query where the results shows Player Opponent ------ -------- John Nancy Jem Albert Smith Daniella A good sample for this question is the query used in …

hi i tried to do this ... hope this helps :+1: create table data ( name varchar(100) ) insert into data values ('John'), ('Nancy'), ('Jem'), ('Albert'), ('Smith'), ('Daniella') ; with cte as ( select ROW_NUMBER() over( order by (select null)) as rn , * from data ) , cte_odd as ( select RO…

Showing results of one column into two columns

Transact-SQL

Ifor August 12, 2020, 3:02pm 8