Results 1 to 2 of 2

Thread: Need help 2

  1. #1
    Join Date
    Nov 2003

    Unanswered: Need help 2

    Need Help 2
    I am currently converting an access DB to MS SQL.

    I am currently trying to figure out how to code this

    I need the count of all rows in colum TERM that is > 1 when its grouped by the COLUM NAME

    Anyone got any Ideas,

  2. #2
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    I do not know the specifics of MS SQL, however a general approach to your problem might be

    select column, count(*)
    from table
    where term > 1
    group by student;
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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