---
title: "Exist Operator in Sql Server?"  
description: "Exist Operator in Sql Server?"  
author: "Manish Kumar"  
published: 2017-12-15  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/23331/exist-operator-in-sql-server  
category: "mssql server"  
tags: ["database", "sql server"]  
reading_time: 1 minute  

---

# Exist Operator in Sql Server?

The EXISTS operator is used to test for the existence of any record in a subquery.

The EXISTS operator returns true if the subquery returns one or more records.

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

## Answers

### Answer by Manish Kumar

The EXISTS operator is used to test for the existence of any record in a subquery.

The EXISTS operator returns true if the subquery returns one or more records.

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


---

Original Source: https://www.mindstick.com/interview/23331/exist-operator-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.