WHERE

SELECT * FROM SchemaName.TableName
WHERE Id > 7

SELECT * FROM SchemaName.TableName
WHERE [Name] = 'Bob' -- if the word is protected seround it with []