Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    9

    Unanswered: Need help for db2 query

    Hi

    I need to write a query with pulls count for a column based on some condition and i need to figure out if the count is less than given constant value.


    example of the query trying with:

    select count(R_id) , G_id from Temp_map
    where x_id is null or x_id = 2
    and count(R_id) < 2
    group by G_id


    thanks for help.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    select count(*) , G_id from Temp_map
    where x_id is null or x_id = 2
    group by G_id
    having count(*) < 2

    WHERE filters the rows
    HAVING filters the Group By
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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