我正在尝试搜索一个名为population的表,该表包含列county
、year
和population
。我试图得到爱尔兰每年的总人口,但不包括都柏林。我试过这个和"NOT IN"one_answers"NOT LIKE",但它们都不起作用。
SELECT
`County`,
`Year`,
SUM(`Population`)
FROM
population
WHERE
`County` NOT 'Dublin'
GROUP BY
`Year`
我想你想要<>
:
SELECT `Year`,
SUM(`Population`)
FROM population
WHERE `County` <> 'Dublin'
GROUP BY `Year`