"P Kishor" asked...
>I don't understand your question at all. I will answer it at the end. > On 2/7/08, jose isaias cabrera <[EMAIL PROTECTED]> 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 > > But, first... why are you using GROUP BY above when you have no > aggregate function (Count, Max, Min, Sum, etc.) in your query? Because of this: sqlite> SELECT PSubClass FROM LSOpenJobs WHERE subProjID = 2190; Pre-Proc Post-Proc DOC-Trans DTP Pre-Proc Pre-Proc Pre-Proc Pre-Proc Pre-Proc Post-Proc Post-Proc Post-Proc Post-Proc Post-Proc DOC-Trans DOC-Trans DOC-Trans DOC-Trans DOC-Trans DTP DTP DTP DTP DTP PM PM PM PM PM PM sqlite> > >> 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? >> > > What is the logic above? Without you telling us why Pre-Doc is before > Post-Proc is before DOC-Trans, and so on, how can we guess what your > logic is for the sort? In other words, please explain what makes the > above sort "special"? Aaah, ok. I am preparing an html file and in it I will list these PSubClasses in this special logical display sequence: 1. Pre-Proc 2. Post-Proc 3. DOC-Trans 4. DTP 5. PM I hope this explains it... thanks, josé _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
