operator not greater than

[Mike Bonner]

Might see if max() will do what you want.

Something like

select field form table-name where max(field) < 10

On Sat, May 19, 2012 at 5:08 PM, william humphrey <
bill at bluewatermaritime.com> wrote:

> How do I do a "!>" in Valentina? I can't find a not greater than operator.
>
> It's a simple select:
>
> select field from table-name where field !> 10
>
> Since there is not a "not greater than" operator I must have to do this
> backwards somehow.
>
> I can't do:
>
> select field from table-name where field < 10
>
> Because then I get all the fields because they all have the value 1 to 10
> in them but because that operator is not there maybe I can do this with
> some kind of range? I'm looking for the field which has 1 to 9 but does not
> have any values greater than that.
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120519/7211f973/attachment.html>