Reylin Mathew

Reylin Mathew

  • 1.6k
  • 279
  • 10.1k

How can I return multiple rows as a single row in sql server

Jun 18 2019 1:34 AM
i have something like this
 
name       date                   id 
a         2070-06-11           23 
b         2070-07-11           35 
a         2070-06-11           39 
c         2070-08-11           46 
d         2070-02-11           50
 
but i want this,
 
name     date       id
a     2070-06-11  23
b     2070-07-11  35
c     2070-08-11  46
d     2070-02-11  50
 
how can i solve this pblm?
thnk in advnce 
 
 

Answers (3)