1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

SQL Issue

Discussion in 'SQL PL/SQL' started by aaryan, Apr 11, 2014.

  1. aaryan

    aaryan Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    i have data like
    x y z
    -----
    b h 10
    b c 10
    h b 10
    b b 10

    i need output

    b h 10
    b c 10
    b b 10
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Post what y0u've written to solve this homework problem; we will help but we won't write your homework for you.
     
  3. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    select <what you want>
    from <where it is>
    where <define your restriction(s)>;

    It really is that simple...

    CJ
     
  4. aaryan

    aaryan Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    please provide me an sql because i have tried many ways i haven't got any solution its not an homework :)
     
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    So post what you have written; we will assist you, we won't write it for you.