Find all tables containing column with specified name Many developers asking is it possible to find a column name in all tables which has columns specified name. So here is query to search a column in a SQL Server database. Search in all tables SELECT c.name AS 'Column', t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name = 'MycolumnName' --specify search column name ORDER BY TableName,Column Search in all tables and views SELECT COLUMN_NAME AS 'Column', TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'MyColumnName' --specify search column name ORDER BY TableName,Column;

filter a list of objects javascript

Rathnakar

could you help me get the desired output from a list using javascript?

let list = [
    { id: 1, name: "a" },
    { id: 1, name: "ab" },
    { id: 1, name: "abc" },
    { id: 2, name: "x" },
    { id: 2, name: "xy" },
    { id: 2, name: "xyz" },
    { id: 2, name: "xyze" },
]

the output I want :

let list2 = [
    { id: 1, name: "abc" },
    { id: 2, name: "xyze" },
]