Home Forums SQL Server 2012 SQL 2012 - General Whats wrong with this query? RE: Whats wrong with this query?

  • July 10, 2014 at 5:36 am

    #1728337

    cstrati (7/10/2014)

    select mvID, title, rating, length ,studio

    from MovieInfo

    where rating not like 'R'

    and

    where (length > 90)

    Seems to be a problem with line 5

    Thanks in Advance.

    There may be a problem with line 2 also. Do you mean

    WHERE rating NOT LIKE 'R%'

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden