[thelist] selecting above and below ranges in a SQL query [long]

rudy r937 at interlog.com
Mon Aug 26 13:25:22 CDT 2002


>  I want the 6 if there is not seven rows.

then 3 queries -- less than, greater, and equal

you cannot combine the equal query with either of the other two, because
you cannot easily flip from LIMIT 3 to LIMIT 4 to include the equal row


rudy





More information about the thelist mailing list