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
