Search Postgresql Archives

Complex SELECT Statement help needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm new to postgres and am trying to display rows in a table that are have a
value between 2 fields. 

The rows I want to display should be selected by the grademin or grademax
fields. I'd like to display the rows in sections that are labeled Grades
3-5, 6-8, and 9-12.

The problem that I am having is I can't figure out how to write a statement
that will check both fields. And, especially when I have values in the like
this:

grademin 4 grademax 12 that I want to show up in all levels
grademin 5 grademax 12 "" 
grademin 6 grademax 9 in 6-9 and 9-12

Below is what I have so far, but it falls flat on it's face when trying to
display rows that don't fall between the specific range. 

How can I check grademin and max in the same statement?


$query = "SELECT
lessonwebid,lessontitle,gradelevel,grademin,grademax,reviewedby FROM
lessonplans WHERE grademin >= 3 OR grademin <= 5";

$query = "SELECT
lessonwebid,lessontitle,gradelevel,grademin,grademax,reviewedby FROM
lessonplans WHERE grademin >= 6 OR grademin <= 8";

$query = "SELECT
lessonwebid,lessontitle,gradelevel,grademin,grademax,reviewedby FROM
lessonplans WHERE grademin >= 9 OR grademin <= 12";

Thanks ahead for any suggestions.
-- 
View this message in context: http://old.nabble.com/Complex-SELECT-Statement-help-needed-tp27691760p27691760.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux