Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

One column to multiple columns in SQL Server based on ID

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 4, rows affected: 4, absolute service time: 0,17 sec 
fork mode |  history
   id email phone workphone
1 1 [email protected] 12345 NULL
2 2 NULL 56789 546789
   id email phone workphone
1 1 [email protected] 12345 NULL
2 2 NULL 56789 546789

    
                
λ
.NET NoSQL database for rapid development