Which of the following SQL statements has correct syntax?

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

Answer 1

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 .

Answer 2

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.

Answer 3

Hi,

This is correct:

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

Answer 4

Why don't you try executing them and find out for yourself?  You will learn more by doing rather than asking.

Answer 5

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.