'group by Time' and 'order by Time'

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

'group by Time' and 'order by Time'

JINHUI
Dears,

Today,I try to improve my table by using:Group by Time and Order by time like following:


no matter what I use by 'group by Time' or 'order by Time',

The time also can not in orders;

why?

Thanks avance

jinhui
Reply | Threaded
Open this post in threaded view
|

Re: 'group by Time' and 'order by Time'

Gwendall Petit
Administrator
Hum, not sure to understand what you want to do.

Note that "Group By" and "Order By" are totaly different.

"Group By" is an aggregative operator.
"Order By" is just a way to sort your table. You can do the same if you click on your field and choose "Sort..."

Regards

Gwendall
Reply | Threaded
Open this post in threaded view
|

Re: 'group by Time' and 'order by Time'

Alexis.G
Moreover, I think that "time" is a keyword in the SQL language.



--
OrbisGIS supporter.