Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    83

    Unanswered: How do I show some results and hide others?

    I have a feeling when I get the answer I'm going to say "DUH!". Hey, it's the day after a holiday. My brain hasn't caught up yet

    I have a query where I am summing a column. I only care to display the results if the sum is greater than 1000.

    SELECT student_id, sum(hours_worked)
    FROM mytable

  2. #2
    Join Date
    Sep 2004
    Posts
    60

    Lightbulb

    Small hint ::

    Use 'Having', after using 'group by' .

  3. #3
    Join Date
    Jan 2004
    Posts
    83
    Thanks for kick-starting my brain.

Posting Permissions

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