Writing Query

[tatarao25]

hi evry one,

my problem statement is i have table as follows

jobId | stagename             | Count

623     Technical Screening      5 
623     Technical InterView      3
623     Second Interview         6
623     Final Interview          7
623     Hr Interview             1

i want Query To Display result as given below

jobId |Technical Screening | Technical InterView |Second Interview | Final Interview |HrInterview

623 5 3 6 7 1

[pritaeas]

http://www.mysqlperformanceblog.com/2006/09/04/group_concat-useful-group-by-extension/

[debasisdas]

show some effort, to get any help.

[tatarao25]

i want to convert above result by using qury that is written in storeprocedure

[debasisdas]

I did not ask what you want ,but what you have tried so far.

[tatarao25]

tried using

SELECT ITEM_CODE,
SUM(IF(RETAIL_ID=’A',SALES,0)) AS ‘A’,
SUM(IF(RETAIL_ID=’B',SALES,0)) AS ‘B’,
SUM(IF(RETAIL_ID=’C',SALES,0)) AS ‘C’
FROM RETAIL_INFO
GROUP BY ITEM_CODE

i will get above resluted table by hardcode stage name

but i want to generate dynamic