CODEWITHSUNDEEP
mysqlsql
user3258468
user3258468

Reputation: 354

List by project_id using queries

I have a a table with following values:

id    employee_id    project_id
1     1              1
2     2              1
3     3              1
4     4              1

How can i list by project_id? using mysql queries?

project_id        employee_id        employee_id        employee_id        employee_id
1                 1                  2                  3                  4

Upvotes: 1

Views: 80

Answers (2)

Zafar Malik
Zafar Malik

Reputation: 6854

Try below query-

SELECT project_id ,SUBSTRING_INDEX(GROUP_CONCAT(employee_id),',',1) AS employee_id1,SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(employee_id),',',2),',',-1) AS employee_id2, SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(employee_id),',',3),',',-1) AS employee_id3, SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(employee_id),',',4),',',-1) AS employee_id4 FROM my_table GROUP BY project_id;

Upvotes: 1

Shrikant Gupta
Shrikant Gupta

Reputation: 127

SELECT project_id, GROUP_CONCAT(employee_id) FROM Table GROUP BY project_id;

It's can be consider ..??

Upvotes: 0

Related Questions