creating constant select statements

[Harald Kirsch <Ha...@raytion.com>]

Hi everyone,

is there a way to generate constant selects, like in

select "four", 5, "six";

I need this to streamline some code which sometimes has a group by and 
sometimes does not have it. With the group by I naturally get

result1 552
result2 234
result4 222

but when there is no group by I get just one single number, but would 
rather like to have

all 789

Therefore I would like to create a command equivalent for

select 'all', count(*) from ...

Is this possible?

Thanks,
Harald.

-- 
Harald Kirsch
Raytion GmbH
Kaiser-Friedrich-Ring 74
40547 Duesseldorf
Fon +49-211-550266-0
Fax +49-211-550266-19
http://www.raytion.com