| Subject | How can I use a group by when I want to group a column divided by 100 |
|---|---|
| Author | Allan Morris Caras |
| Post date | 2001-08-09T07:06:04Z |
How can I use group by when I want to use a statement
like this one:
select cast(column_name/100) from my_table
group by column_name/1000
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
like this one:
select cast(column_name/100) from my_table
group by column_name/1000
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/