MSSQL DISTINCT Unique Duplicate Rows Tutorial

Use of Unique Duplicate Rows In MSSQL Database Server Tutorial Example

Run microsoft sql server management studio query editor or any client tools you like then copy & paste the below code to get unique or duplicate rows from a table by sql command or statement in MSSQL Database Server Tutorial Example

   -- Northwind

   -- Unique Data
   SELECT DISTINCT TitleOfCourtesy FROM Employees

   -- With Duplicate Data
   SELECT TitleOfCourtesy FROM Employees
   Make sure that you have "Northwind" sample database available.
   /* */ is multiline code comments in MSSQL
   -- is comment in MSSQL
   -- in fact it is comment in Oracle and MySQL as well

Use of Unique Duplicate Rows In MSSQL Database Server Tutorial Example - Result in Microsoft Sql Server Management Studio Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..