subject:"\[sqlite\] Help\-using Case in query"

Re: [sqlite] Help-using Case in query

2009-10-16 Thread dave lilley

how about this select * from TestName where History > 399 and History < 501 the above SQL is saying (in laymans terms) >From the table TestName gather all the column data and display ONLY those rows where data in History column is greater than 399 and is below 501. _OR_ Select ONLY those r

Re: [sqlite] Help-using Case in query

2009-10-12 Thread Igor Tandetnik

yvette roberson wrote: > I am definitely an novice in writing but trying to practice and get > up to speed and would appreciate any help: > > In laymen terms I have a quey that I am trying to write with the > following columns > TestName (where testname '1' = History, TestName '2'=Math, TestName

[sqlite] Help-using Case in query

2009-10-12 Thread yvette roberson

I am definitely an novice in writing but trying to practice and get up to speed and would appreciate any help: In laymen terms I have a quey that I am trying to write with the following columns TestName (where testname '1' = History, TestName '2'=Math, TestName '3'= Western Civilization, TestName