ansaurus

Question

sql statement help

Answer 1

+4 A:

SELECT name FROM people WHERE age > 15

Mark Byers 2010-01-14 09:34:39

That will get the people with an age of 16 and above. You want to use >= 15 to get the people with an age of 15 and above.

Guffa 2010-01-14 09:49:35

Answer 2

+1 A:

select name from people where age > 15

Alon 2010-01-14 09:34:50

Answer 3

+2 A:

SELECT name, age
FROM people
WHERE age >= 15

Anthony Faull 2010-01-14 09:35:35

+1 for using the >= operator

Guffa 2010-01-14 09:50:56

sql statement help