Results 1 to 2 of 2

Thread: Inner Query

  1. #1
    Join Date
    Jan 2006
    Posts
    3

    Unanswered: Inner Query

    Hi friends

    This is my First quey to this forum.
    I am using MYSQL 4.0.26-nt version and i am unable to write the query

    select pointsearned
    from performance
    where pointsearnesd=(select max(pointsearned) from performance)


    please can any one help me...

  2. #2
    Join Date
    Jun 2005
    Posts
    23
    Quote Originally Posted by suneshkumar
    Hi friends

    This is my First quey to this forum.
    I am using MYSQL 4.0.26-nt version and i am unable to write the query

    select pointsearned
    from performance
    where pointsearnesd=(select max(pointsearned) from performance)


    please can any one help me...
    you need mysql 4.1 and above to run that query

Posting Permissions

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