Thanks!
--
http://www.xing.com/profile/Dmitri_Pissarenko
http://dapissarenko.blogspot.com/
OK, sorry, forgot to name the inner table (x):
SELECT * FROM (your_SELECT_with_GROUP_BY) x ORDER BY ...
On 29.6.2007, at 10:28, Dmitri Pissarenko wrote:
Hello!
On 6/28/07, Peter Ondruska <[EMAIL PROTECTED]> wrote:
SELECT * FROM (your_current_SELECT_statement_with_GROUP_BY) ORDER
BY ...
Th
Hello!
On 6/28/07, Peter Ondruska <[EMAIL PROTECTED]> wrote:
SELECT * FROM (your_current_SELECT_statement_with_GROUP_BY) ORDER BY ...
Thanks for your answer!
When I do this, I'm getting this error:
SQL State = 42X01 SQL Code = 3 SQL Message = Syntax error:
Encountered "ORDER" at line 5,
SELECT * FROM (your_current_SELECT_statement_with_GROUP_BY) ORDER BY ...
On 28.6.2007, at 15:03, Dmitri Pissarenko wrote:
Hello!
Now I understand why this error happens: GROUP BY doesn't take into
account the sort order (Starttime).
Is there an elegant way to make GROUP BY take into account s
Hello!
Now I understand why this error happens: GROUP BY doesn't take into
account the sort order (Starttime).
Is there an elegant way to make GROUP BY take into account sort order
of the records?
TIA
Dmitri Pissarenko
Hello!
Thanks for your hint!
The idea with GROUP BY is really good.
I tried to use it, but now have following problem.
I have these data:
Datetime| Location | SomeDataAsString
+---+-
14.05.2007 10:58:55 | LOC_01| A, B
14.05.2007 11:
Dmitri Pissarenko wrote:
Hello!
I have Table A with following fields:
1) A.Date/time
2) A.Location
In table B for each record of table A there is zero, one or more
records with following fields:
1) B.name
2) B.type
B.type can take on one of exactly four values, say "TYPE1", "TYPE2",
"TYPE3",
Hello!
I have Table A with following fields:
1) A.Date/time
2) A.Location
In table B for each record of table A there is zero, one or more
records with following fields:
1) B.name
2) B.type
B.type can take on one of exactly four values, say "TYPE1", "TYPE2",
"TYPE3", "TYPE4".
I need to view
