PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Fri Sep 22, 2017 1:15 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Cross Tab Query
PostPosted: Thu Aug 25, 2016 11:10 pm 
Offline
Forum Newbie

Joined: Sat Nov 09, 2013 2:07 am
Posts: 7
Sir I want to generate a query which will convert data from rows to columns

I have this table

Image

I want to get this result

Image

Workers amount will go to column in relevant data

Group by code.

Please help


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group