sql 查询 表设计为key value 形式，搜key对应的value的形式

SELECT xxxx       as xxxx,
       xxx          as xxx,

FROM (
         SELECT *
         FROM (SELECT be.setup_date      as                                              setup_date,
                      be.business_status as                                              business_status,
                      be.entity_id       as                                              entity_id,
                      max(case p.key when 'xxxxx' then value else '' end)         xxxx,
 

               WHERE be.entity_type_cd = 'xxxx'
               GROUP BY be.entity_id) ipotable
         WHERE 1 = 1) xxx
LIMIT 0 , 10;