7 Replies Latest reply on Oct 3, 2007 9:57 PM by Aketi Jyuuzou

    count problem

    user598242
      I have a table with two columns: id, package
      like:
      id package
      -----------------------------
      1 TV
      2 CD
      1 CD
      1 DVD
      3 TV
      I want get the id which has package 'TV' and his total records in this table is less than 4.
      How should i do? Thanks