Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Unanswered: Average function [SQL]

    I'm on AIX 5.2 DB2 8.1.4

    Does anyone know how I can get this query
    to return decimal values in the first column?

    The underlying data type is smallint.

    select avg(v_alder), year(d_dodsdto) as aar, mast.cprkoen(k_cpr) as kon
    from dar.t_dodsaars
    where year(d_dodsdto)>1995
    group by year(d_dodsdto), mast.cprkoen(k_cpr)
    order by 2, 3;

    Thank You
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Try using the cast function to change the data type to decimal.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Talking Yup

    Hi Marcus

    Thanks - I did, and it works.

    HTH
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •