Sql statement help

Question

I have a table called people and I have 2 columns, name and age

How can I choose names over the age of 15, for example?

thank

+3

John terry Jan 14 '10 at 9:33

3 answers

SELECT name, age
FROM people
WHERE age >= 15

+2

Anthony faull Jan 14 '10 at 9:35

select name from people where age > 15

+1

Alon Jan 14 '10 at 9:34

Mark byers · Accepted Answer · 2010-01-14T09:34:39+0000

SELECT name FROM people WHERE age > 15