Developer Network >> Other Programming >> Database

is there any error in in SQL?

is there any error in in SQL?
"SELECT TOP 100 name, sum(values) as num FROM Rec Group BY name order by num"
when it run at ACCESS 2000. it prompt "input value of num" .
I want sort by "num" only.
but why it want me input value to it?

[269 byte] By [liuty] at [2007-11-18 19:04:32]

«« Reading keyboard input buffer?
»» newbie - how do i set a int var to a char

# 1 Re: is there any error in in SQL?

[Moved thread]

Andreas Masur at 2007-11-9 13:37:28 >

# 2 Re: is there any error in in SQL?

access thinks that num is an input parameter.
use this :

SELECT TOP 100 name, sum(values) as num FROM Rec Group BY name order by sum(values)

hspc at 2007-11-9 13:38:28 >