| Group By and Aggregate functions possible in SQL? [message #52516] |
Tue, 28 June 2005 14:04  |
Eclipse User |
|
|
|
Originally posted by: no.spam.com
Does anyone know if there are limitations on SQL in BIRT? In other words,
if working with a flat data source is something like
SELECT Company,SUM(Amount) FROM Sales
GROUP BY Company
even possible?
|
|
|
|
| Re: Group By and Aggregate functions possible in SQL? [message #52762 is a reply to message #52516] |
Wed, 29 June 2005 17:18  |
| Eclipse User |
|
|
|
If you are interested in the flatfile data source - the query text language
used by that data set is "SQL-like". It doesn't support GROUP BY, WHERE,
ORDER BY etc.
For JDBC data sources, the SQL is passed to the JDBC driver for execution,
so whatever SQL that's valid for your DBMS is supposed in BIRT.
Gary Xue
BIRT Committer
"Mark S." <no@spam.com> wrote in message
news:910d9ed947fbb3a6e3486e6606f69a9b$1@www.eclipse.org...
> Does anyone know if there are limitations on SQL in BIRT? In other words,
> if working with a flat data source is something like
>
> SELECT Company,SUM(Amount) FROM Sales
> GROUP BY Company
>
> even possible?
>
|
|
|
Powered by
FUDForum. Page generated in 0.02927 seconds
Home