Помогите с запросиком а

← →
GAlex (2003-04-08 13:41) [0]

select top 10 cast(convert(char,call_time,104) as datetime),sum(money)
from dbo.user_log
group by cast(convert(char,call_time,104) as datetime)
order by cast(convert(char,call_time,104) as datetime)

Работает, а
select top 10 cast(convert(char,call_time,104) as datetime) as ddd,sum(money)
from dbo.user_log
group by ddd
order by ddd
Не хочет =(

← →
chdv (2003-04-08 13:53) [1]

и не будет.
попробуй так
select ddd, sum(money)
from
(select top 10
cast(convert(char,call_time,104) as datetime) as ddd,
money
from dbo.user_log)
group by ddd
order by ddd

← →
Johnmen © (2003-04-08 14:00) [2]

Использование алиасов полей недопустимо при обращении к ним...

← →
GAlex (2003-04-08 14:42) [3]

2 chdv так не хочет работать =(

select ddd, sum(money)
from
(select top 10
cast(convert(char,call_time,104) as datetime) as ddd,
money
from dbo.user_log) a
group by ddd
order by ddd

Помогите с запросиком а Найти похожие ветки