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

Question

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

Jignesh Kumar · Answer

Hi Reylin,   Please use below query, With  CTE  as (   select   name ,  date , ID, row_number() over(partition  by   name   order   by   name )  as  rankID  from  Test   )   select   name ,  date , ID  from  CTE  where  rankID= 1

Sivakumar Koneti · Answer

see this once you can get an idea    https://stackoverflow.com/questions/8005846/sql-server-combining-multiple-rows-into-one-row

Rajanikant Hawaldar · Answer

Hi  Reylin,   Please go through bewlo thread   https://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/   https://www.c-sharpcorner.com/UploadFile/860b29/concatenate-multiple-rows-within-single-row-in-sql-server-20/   let me know if any additional info required   Thanks