query to select rows based on comparision of columns

• DURGESH-769360

  SSC Eights!

  Points: 968

  More actions

  May 29, 2009 at 11:47 pm

  #73096

  hi all,

  I have a table that contains hierarical data as follows

  col1 col2

  aa null

  aa.abc aa

  aa.axy aa

  aa.abc.01 aa.abc

  aa.abc.02 aa.abc.01

  aa.axy.01 aa.axy

  aa.axy.011 aa.axy

  aa.axy.012 aa.axy.01

  but i need the output as follows

  col1 col2

  aa null

  aa.abc aa

  aa.abc.01 aa.abc

  aa.abc.02 aa.abc.01

  aa.axy aa

  aa.axy.01 aa.axy

  aa.axy.012 aa.axy.01

  aa.axy.011 aa.axy

  Sorry, I was not completed my question due some urgent process but now I edited it.

  Help me to solve this issue

  Thanks in advance

  Regards

  Durgesh

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  May 30, 2009 at 12:37 am

  #1002360

  Tell me Clearly ,What's your expectations?

• arun.sas

  SSChampion

  Points: 11831

  More actions

  May 30, 2009 at 12:45 am

  #1002361

  DURGESH (5/29/2009)

  ---

  hi all,

  I have a table as follows

  col1 col2

  aa null aa.abc aa aa.abc.01 aa.abc aa.abc.02 c aa bb ab

  Hi,

  For the better assistance to your requirement, at least do/submit the a) the table schema with some data b) result sets/formats c) your trial coding/statements

  ARUN SAS

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  May 30, 2009 at 2:48 am

  #1002380

  DURGESH (5/29/2009)

  ---

  hi all,

  I have a table as follows

  col1 col2

  aa null

  aa.abc aa

  aa.abc.01 aa.abc

  aa.abc.02

  ac aa

  bb ab

  Where's the question?? How about reading this article on how to post questions in forums to get better responses[/url].

  --Ramesh
  

  ---