drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjiv Kumar <ktrsan...@gmail.com>
Subject How to get multiple row value as a single column
Date Wed, 04 Jan 2017 11:15:05 GMT
Hello
        I need help.Suppose I have one table having categoryName,
categoryID, customerName.
EXAMPLE:-
categoryName categoryID customerName
  C1 10 Cust1
  C1 10 Cust3
  C1 10 Cust4
  C2 11 Cust2

In above table Multiple Customers having same Category Name.

How to get customer name which have same category name in a single row
using drill query ?
 Like:-

categoryName customerName
 C1 Cust1,Cust3,Cust4
 C2 Cust2









 -------------------------
Thanks & Regards
   Sanjiv Kumar

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message