How to get Distinct Records from a table in SQL Server - SQL Server / TSQL Tutorial 112

preview_player
Показать описание
SQL Server / T-SQL Tutorial Scenario:
How to get Distinct Records from a table in SQL Server

You are working as SQL Server developer, you need to get distinct (different) records from a table. Which statement will you use to get unique records from a table.

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
TSQL Tutorial for beginners
SQL Server Tutorial step by Step
Рекомендации по теме
Комментарии
Автор

Question: if you self join a table in two foreign keys and only want distinct rows, using distinct does that get rid of duplicates of the combination of row cells, in other words self joining creates duplicate rows but in different columns

jayjayf