Is this what you're after?
create table LSOpenJobs (PSubClass);
insert into lsopenjobs values ('DOC-Trans');
insert into lsopenjobs values ('DTP');
insert into lsopenjobs values ('PM');
insert into lsopenjobs values ('Post-Proc');
insert into lsopenjobs values ('Pre-Proc');
select * from lsopenjobs
order by case psubclass
when 'Pre-Proc' then 1
when 'Post-Proc' then 2
when 'DOC-Trans' then 3
when 'DTP' then 4
when 'PM' then 5
end;
jose isaias cabrera wrote:
> Greetings.
>
> I would like to have the results of a select be returned sorted in an
> specific way. Let me show you what I mean:
>
> sqlite> SELECT PSubClass FROM LSOpenJobs WHERE subProjID = 2190 GROUP BY
> PSubClass;
> DOC-Trans
> DTP
> PM
> Post-Proc
> Pre-Proc
> sqlite>
>
> What I would like is to have the SELECT result be,
>
> Pre-Proc
> Post-Proc
> DOC-Trans
> DTP
> PM
>
> is this possible? Yes, I know I can sort it in the program, but how can I
> get this special sort from the DB?
>
> thanks,
>
> josé
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
