Post reply

in built function quer

  • April 27, 2012 at 4:38 am

    #273302

    Hi All,

    Got below error:

    'average' is not a recognized built-in function name.

    while executing the below query

    select avg(salary) from #employee

    Please advice me.

    Thanks in Advance.

    Regards,

    Faroz

  • April 27, 2012 at 4:52 am

    #1480280

    i just ran the following

    select AVG(convert(float,id)) from sysobjects

    seems to work fine for me

    are you sure didn't type in

    select AVERAGE(salary) from #table - that would explain the error

    MVDBA

  • April 27, 2012 at 5:21 am

    #1480297

    +1

    The Error is:

    'average' is not a recognized built-in function name.

    But I can't see 'average' anywhere in your query.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • April 27, 2012 at 5:30 am

    #1480305

    @mike-2 Vessey

    yeah am sure

    i didn't type Select Average(salary) from #employee

    Thanks for Mike Vessey and Vinu Vijayan

  • April 27, 2012 at 5:34 am

    #1480307

    You sure are welcome....:-)

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply