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 query

Discussion in 'SQL PL/SQL' started by Vik@s, Dec 29, 2016.

  1. Vik@s

    Vik@s Active Member

    Messages:
    11
    Likes Received:
    1
    Trophy Points:
    110
    Location:
    India
    In Query data show as the Sr No o row display Months wise data.
    where one year is finish date
    [ upload_2016-12-29_18-10-4.png
    Data show one year finish start next year with which months is coming first

    upload_2016-12-29_18-9-41.png
     
    Last edited: Dec 29, 2016
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    769
    Likes Received:
    148
    Trophy Points:
    830
    Location:
    Russian Federation
  3. Vik@s

    Vik@s Active Member

    Messages:
    11
    Likes Received:
    1
    Trophy Points:
    110
    Location:
    India
    Change the Format please check it.
     
  4. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    769
    Likes Received:
    148
    Trophy Points:
    830
    Location:
    Russian Federation
    What is your Oracle version ?
    Please,provide here a script of creation of tables and a script of filling of tables.Then will be possible to help you with writing of a script.
     
    Last edited: Dec 29, 2016
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,645
    Likes Received:
    372
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    What, exactly, is the purpose of this?