That causes an error:
ERROR: syntax error at or near "ORDER"
LINE 2: SELECT row_number(ORDER BY records DESC) as id, a...
^
Regards
Johann
On 9 April 2013 15:11, Niphlod <[email protected]> wrote:
> try with
>
> SELECT row_number(ORDER BY records DESC) as id, a.*
> FROM (
>
> SELECT sabinet.jt AS journal, count(*) AS records
> FROM sabinet.sabinet
> GROUP BY sabinet.jt
> ) a
>
>
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
