2 Replies Latest reply: Apr 22, 2015 7:44 PM by Marcelo Fonseca RSS

    Line Ordering and Sequence Variation

      Hi,

       

      This is my first post here, sorry about my bad English and  if i mistake something here. I would like some help in the problem below.

      I have a database with 5 date columns, and i need to put each line in a crescent order, and know the types of sequence variation that i have like the tables below:

       

      Data base Example:

       

      Date1Date2Date3
      01/01/201502/02/201515/01/2015
      02/02/201501/01/201515/01/2015
      02/02/201515/01/201501/01/2015

       

      Put in order:

       

      Column1Column2Column3
      01/01/201515/01/201502/02/2015
      01/01/201515/01/201502/02/2015
      01/01/201515/01/201502/02/2015

       

      Types of variation:

       

      Column1Column2Column3
      Date1Date3Date2
      Date3Date1Date2
      Date3Date2Date1