Answered Questions

  • Mar 02 2011
    05:49 PM
    11198
    36

    Identify Social Security Numbers

    • preetigupta107

    How will you verify that there are no social security numbers greater than or less than 9 digits long in a table called customer_info? Write the SQL query that will identify any social security numbers that do not meet this criteria

    Deepak

    • Aug 13th, 2015

    Use Not Equal to instead 

    Code
    1. SELECT * FROM customer_info WHERE length(SSN_No)<>9

    Poorva

    • Aug 12th, 2015

    We need to use len and not length in the syntax