Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    Interview Questions

    Uploaded by

    Rajesh T

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Interview Questions

    Uploaded by

    Rajesh T
    7 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    7 views1 page

    Interview Questions

    Uploaded by

    Rajesh T

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    of 1

    create table online_shop(retailer varchar2,brand varchar2);

    insert into online_shop(retailer,brand)


    values
    ('AMAZON','ONPLUS'),
    ('WALLMART','REALME'),
    ('SNAPDEAL','NOKIA'),
    ('FLIPKART','MI'),
    ('WALMART','MI');
    select * from online_shop;

    retailer oneplus realme

    retailer oneplus realme nokia MI


    amazon yes no no no
    wallmart no yes no no
    snapdeal no no yes no
    flipkart no no no yes
    wallmart no no no yes

    SELECT * FROM
    (
    SELECT retailer, brand
    FROM online_shop
    )
    PIVOT
    (
    count(brand)
    FOR brand IN ('ONPLUS','REALME','NOKIA','MI')
    )

    retailer oneplus realme nokia MI


    amazon 1 0 0 0
    wallmart 0 1 0 0
    snapdeal 0 0 1 0
    flipkart 0 0 0 1
    wallmart 0 0 0 1

    You might also like