---
title: "How to select unique records from a table?"  
description: "How to select unique records from a table?"  
author: "Shrikant Mishra"  
published: 2019-05-06  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/23511/how-to-select-unique-records-from-a-table  
category: "mssql server"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# How to select unique records from a table?

Select unique records from a table by using **DISTINCT** keyword.

```
Select DISTINCT StudentID, StudentName from Student.
```

## Answers

### Answer by Shrikant Mishra

Select unique records from a table by using **DISTINCT** keyword.

```
Select DISTINCT StudentID, StudentName from Student.
```


---

Original Source: https://www.mindstick.com/interview/23511/how-to-select-unique-records-from-a-table

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