In MySQL GROUP_CONCAT functionality is comma separated values grouped by a defined key.
In MySQL GROUP_CONCAT functionality is comma separated values grouped by a defined key.
Questions tagged [sql-server-group-concat]
62 questions
-2
votes
2 answers
Find the genres that have at least 2 same directors, then print common genres and director id?
The dataset is like this:
g1 = {d1,d3,d5}
g2 = {d1,d3,d2}
g3 = {d4,d3,d5}
I have the following table called director_genre:
director_id | genre
d1 g1
d1 g2
d2 g2
d3 …
Sahil Kamboj
- 390
- 2
- 5
- 16
-2
votes
3 answers
How to concat values which retrieved from database
I am executing this query in SQL Server 2008
SELECT (CONVERT(DATE, GETDATE()))
and it shows the result 2013-07-22.
I need to print this result as 22713, where 22 is the date 7 is the month 13 is the year.
How could I do this?
sidhewsar
- 136
- 2
- 8
- 17