Re: [sqlite] Sorting the result of a select. Is this possible?

"P Kishor" wrote... > On 2/8/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote: >> >> "P Kishor" replied... >> >> >> > On 2/7/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote: >> >> >> >> "P Kishor" asked... >> >> >> >> >> >> >I don't understand your question at all. >> >> >> >> I will answer i

Re: [sqlite] Sorting the result of a select. Is this possible?

On 2/8/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote: > > "P Kishor" replied... > > > > On 2/7/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote: > >> > >> "P Kishor" asked... > >> > >> > >> >I don't understand your question at all. > >> > >> I will answer it at the end. > >> > >> > On 2/7/08,

Re: [sqlite] Sorting the result of a select. Is this possible?

"P Kishor" replied... > On 2/7/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote: >> >> "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

Re: [sqlite] Sorting the result of a select. Is this possible?

On 2/7/08, jose isaias cabrera <[EMAIL PROTECTED]> wrote: > > "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 sel

Re: [sqlite] Sorting the result of a select. Is this possible?

"Trey Mack" beautifully wrote... > 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 lsop

Re: [sqlite] Sorting the result of a select. Is this possible?

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 lsopenjo

Re: [sqlite] Sorting the result of a select. Is this possible?

"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: >>

Re: [sqlite] Sorting the result of a select. Is this possible?

"jose isaias cabrera" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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-Tra

Re: [sqlite] Sorting the result of a select. Is this possible?

I don't understand your question at all. 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 = 2

[sqlite] Sorting the result of a select. Is this possible?

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