It would be ok to have duplicates of school_id. I just want to make sure that new_id is unique.
Jay Sprenkle
<[EMAIL PROTECTED]
com> To
[email protected]
09/30/2005 01:03 cc
PM
Subject
Re: [sqlite] Getting a Unique
Please respond to column from a query
[EMAIL PROTECTED]
te.org
Won't you get duplicates rows of school_id, 2
when classtype = 2?
On 9/30/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
>
> 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
>
>
--
---
The Castles of Dereth Calendar: a tour of the art and architecture of
Asheron's Call
http://www.lulu.com/content/77264
