compress group-by

Hi SQL Masters,

Is there a way to compress multiple rows returned from group-by query into a single row? (such as compress results before 1990) The result should look something like:

                                Result
----------------------------------------
Before 1990            89766
1991                         1000
1992                         2000
1993                         2200

Thanks a lot

HastenThunder Received on Mon Jul 12 2004 - 10:22:50 CDT