locked
Which of the following SQL statements has correct syntax? RRS feed

  • Question

  • Which of the following SQL statements has correct syntax?

    <input name="Q" type="radio" value="199" />SELECT * FROM Table1 WHERE Column1 => 10

    <input name="Q" type="radio" value="201" />SELECT * FROM Table1 WHERE Column1 = = 10

    <input name="Q" type="radio" value="200" />SELECT * FROM Table1 WHERE Column1 >= 10

    Answer

    Monday, October 14, 2013 11:44 PM

Answers

  • Hi,

    the correct choice must be this one :

    <input name="Q" type="radio" value="200" />SELECT * FROM Table1 WHERE Column1 >= 10

    Hope that can help .

    • Proposed as answer by Eshani Rao Tuesday, October 15, 2013 1:23 AM
    • Marked as answer by Allen Li - MSFT Wednesday, October 23, 2013 8:57 AM
    Monday, October 14, 2013 11:49 PM

All replies

  • Hi,

    the correct choice must be this one :

    <input name="Q" type="radio" value="200" />SELECT * FROM Table1 WHERE Column1 >= 10

    Hope that can help .

    • Proposed as answer by Eshani Rao Tuesday, October 15, 2013 1:23 AM
    • Marked as answer by Allen Li - MSFT Wednesday, October 23, 2013 8:57 AM
    Monday, October 14, 2013 11:49 PM
  • SELECT * FROM Table1 WHERE Column1 >= 10 --is the valid syntax.

    Please read the below:

    http://technet.microsoft.com/en-us/library/ms189863(v=sql.105).aspx


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Tuesday, October 15, 2013 6:25 AM
  • Hi,

    This is correct:

    <input name="Q" type="radio" value="200" />SELECT * FROM Table1 WHERE Column1 >= 10

    Tuesday, October 15, 2013 7:12 AM
  • Why don't you try executing them and find out for yourself?  You will learn more by doing rather than asking.
    Tuesday, October 15, 2013 1:25 PM
  • Why don't you try executing them and find out for yourself?  You will learn more by doing rather than asking.

    Spot On. :)

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Tuesday, October 15, 2013 1:41 PM