vinceinhiding
Programmer
I have a table called people. Each person has a name, and income. I want to produce a set of records of people who have an income higher than that of a specific person (BOB). I want to refer to BOB's income as a select statement so that if it changes later on, the statement still holds it conditions.
I tried something like this:
SELECT name, income
FROM people
WHERE income > (SELECT income FROM people WHERE name = 'BOB')
That didnt work, how do i do this????
I tried something like this:
SELECT name, income
FROM people
WHERE income > (SELECT income FROM people WHERE name = 'BOB')
That didnt work, how do i do this????