| Subject | Re: [ib-support] SQL query: how to group by a function |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2001-07-24T13:20:16Z |
Hi Bruno!
position, e.g.
SELECT PIN, NAME
FROM PERSON
ORDER BY 2
will order by NAME. The same applies if you do some calculations as part of
your SELECT - and I guess that's were you'll use your functions.
GROUP BY might be trickier and I think you may have to use stored
procedures, but I'll leave that answer to someone else...
Set
>Interbase does not support GROUP BY / ORDER BY with funcions ? I have aORDER BY should be no problem. You can always order by the column's ordinal
>lot of Row funcions in oracle and ill need them to migrate my application!
position, e.g.
SELECT PIN, NAME
FROM PERSON
ORDER BY 2
will order by NAME. The same applies if you do some calculations as part of
your SELECT - and I guess that's were you'll use your functions.
GROUP BY might be trickier and I think you may have to use stored
procedures, but I'll leave that answer to someone else...
Set