Enjoy
C
15 June 2015
How do I - Select data from a table using TSQL while not returning any duplicates?
When working with large lists of data that are not guaranteed to be unique, you often have to filter out duplicate values. To do this in SQL Server using TSQL, you can leverage the GROUP BY/HAVING combination of statements thus:
Subscribe to:
Post Comments (Atom)
-
Ever wondered what the new SharePoint Online URLs are all about? Take for example https://cjvandyk.sharepoint.us/:x:/r/sites/Site1... What ...
-
Every so often, you run across the need to redirect a page somewhere else, like after a server migration when DNS isn’t used. By simply addi...
-
When using NuGet, we can easily run into assembly reference issues. A notorious error message is: CS0012: The type ‘System.Object’ is def...
No comments:
Post a Comment
Comments are moderated only for the purpose of keeping pesky spammers at bay.