t-sql check if a record exists code example

Example: SQL check if record exist

SELECT column_name(s)
FROM table_name
WHERE EXISTS
(SELECT column_name FROM table_name WHERE condition);