order by to return null values

• Lotus

  Ten Centuries

  Points: 1170

  More actions

  January 26, 2009 at 12:17 pm

  #155180

  I have 3 columns in one table.

  Col1, Col2, Col3.

  The data in these columns has data, and some null values. For Eg:

  Col1 Col2 Col3

  Data1 Data2 Data3

  null null null

  Data1a Data2a null

  Data1b null Data3a

  null Data2b Data3b

  I need to run a Select query, such that the results return with where all the 3 columns have null values, then atleast 1 or more null values, and then with data in all columns.

  Let me know how I can write a query to return data

  Thanks

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  January 26, 2009 at 12:23 pm

  #932774

  select

  *

  from

  MyTable

  order by

  case

  when col1 is null and col2 is null and col3 is null

  then 1

  when col1 is null or col2 is null or col3 is null

  then 2

  else 3

  end