3
Answers

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

Reylin Mathew

Reylin Mathew
5y
1.1k
1
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)
Next Recommended Forum