Smtxwiki: Smtxwiki moved page Transpose to Transpose in database queries

2025-01-17T10:24:12Z

Smtxwiki moved page Transpose to Transpose in database queries

← Older revision	Revision as of 12:24, 17 January 2025
(No difference)

Smtxwiki: 1 revision imported

2020-05-25T20:44:31Z

1 revision imported

← Older revision	Revision as of 22:44, 25 May 2020
(No difference)

Smtxwiki: Created page with "Sometime you want to transpose data from rows into columns. For example, the person_extra table contains values that belong to persons, but the data is stored as rows. Here's..."

2016-12-19T09:36:36Z

Created page with "Sometime you want to transpose data from rows into columns. For example, the person_extra table contains values that belong to persons, but the data is stored as rows. Here's..."

New page

Sometime you want to transpose data from rows into columns. For example, the person_extra table contains values that belong to persons, but the data is stored as rows. Here's a query to get the desired result:

select
person_id,
MAX( CASE fieldname WHEN 'Person_fieldname1' THEN fieldvalue END) as Field1name,
MAX( CASE fieldname WHEN 'Person_fieldname2' THEN fieldvalue END) as Field2name,
email
from personextra
inner join person on person.id=personextra.person_id
where (fieldname = 'Person_fieldname1' or fieldname = 'Person_fieldname1') and person.isactive=1 and fieldvalue <> ''
group by person_id, email

Transpose in database queries - Revision history

Smtxwiki: Smtxwiki moved page Transpose to Transpose in database queries

Smtxwiki: 1 revision imported

Smtxwiki: Created page with "Sometime you want to transpose data from rows into columns. For example, the person_extra table contains values that belong to persons, but the data is stored as rows. Here's..."