如何检索包含和排除特定键的列表？

const data = [
  { name: 'John', age: 25 },
  { name: 'Jane', age: 30 },
  { name: 'Bob', age: 35 }
];

// 检索包含特定键的列表
const filteredList = data.filter(item => item.hasOwnProperty('name'));
console.log(filteredList);

// 检索排除特定键的列表
const excludedList = data.filter(item => !item.hasOwnProperty('age'));
console.log(excludedList);

-- 检索包含特定键的列表
SELECT * FROM table_name WHERE column_name IS NOT NULL;

-- 检索排除特定键的列表
SELECT * FROM table_name WHERE column_name IS NULL;