www.webdeveloper.com
Results 1 to 2 of 2

Thread: Firebird Crosstab

Hybrid View

  1. #1
    Join Date
    Jul 2013
    Posts
    2

    Firebird Crosstab

    I'm working with a database Firebird 2.5 my question and can generate a query or procedures, for example

    my table

    CREATE TABLE COUNTRY
    (REGION VARCHAR2 (20),
    COLOR VARCHAR2 (20))

    INSERT VALUES


    REGION COLOR
    -------------------------------------------------- ----
    Malta RED
    Malta GRAY
    Brazil GREEN ON RED
    Brazil WHITE


    I would like to have this result


    REGION GRAY GREEN ON RED RED WHITE
    -------------------------------------------------- -
    Brazil 0 1 0 1
    Malta 1 0 1 0

    I thank you in advance for your help

  2. #2
    Join Date
    Jul 2013
    Posts
    2
    you can create cross-tables in Firebird
    Thanks for any help

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles