If a database table contain duplicate records the it is easy to select unique records by using DISTINCT function. but when a .Net DataTable contain duplicate records then, there no built-in function to remove or select unique records from a DataTable.

This article explains, how to use Simple CASE Expression and Searched CASE Epxression in SQL Server (T-SQL) or as a formula of a particular column.