Results 1 to 3 of 3

Thread: Query ?

  1. #1
    Join Date
    Aug 2002
    Posts
    35

    Unanswered: Query ?

    SELECT CUSTOMER_id,
    COUNT(VIN) as X
    FROM VEHICLE
    WHERE X > 100
    group by CUSTOMER_id

    Why X is giving problem
    vasu

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Query ?

    Originally posted by k_vasu
    SELECT CUSTOMER_id,
    COUNT(VIN) as X
    FROM VEHICLE
    WHERE X > 100
    group by CUSTOMER_id

    Why X is giving problem
    Try this:

    SELECT CUSTOMER_id,
    COUNT(VIN) as X
    FROM VEHICLE
    group by CUSTOMER_id
    having count(vin) > 100

  3. #3
    Join Date
    Aug 2002
    Posts
    35
    Thank you very much.
    vasu

Posting Permissions

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