[sqlite] Getting a Unique column from a query

[njhinder]

is it possible to use a Distinct or Unique on a column such as:

SELECT school.schoolID AS ID,
CASE WHEN  class.classtype= 2 THEN class.classtype ELSE teacher.teacherID
END AS unique(new_id) FROM Region


SELECT school.schoolID AS ID,
CASE WHEN  class.classtype= 2 THEN class.classtype ELSE teacher.teacherID
END AS distinct(new_id) FROM Region


I do not want any duplicates of the new_id.

Thanks!
Nicole Hinderman