Top "Unique" questions

How to select only the first rows for each unique value of a column

Let's say I have a table of customer addresses: CName | AddressLine ------------------------------- John Smith | 123 Nowheresville Jane Doe | 456 Evergreen Terrace John …

sql sql-server tsql select unique

Using .Select and .Where in a single LINQ statement

I need to gather Distinct Id's from a particular table using LINQ. The catch is I also need a WHERE …

c# linq unique distinct

pandas unique values multiple columns

df = pd.DataFrame({'Col1': ['Bob', 'Joe', 'Bill', 'Mary', 'Joe'], 'Col2': ['Joe', 'Steve', 'Bob', 'Bob', 'Steve'], 'Col3': np.…

python pandas dataframe unique

How do I remove duplicate items from an array in Perl?

I have an array in Perl: my @my_array = ("one","two","three","two","three"); How do I remove the duplicates …

perl arrays unique duplicates

Create a unique number with javascript time

I need to generate unique id numbers on the fly using javascript. In the past, I've done this by creating …

javascript time numbers unique

Count unique values in a column in Excel

I have an .xls file with a column with some data. How do I count how many unique values contains …

excel unique

Mysql: Select rows from a table that are not in another

How to select all rows in one table that do not appear on another? Table1: +-----------+----------+------------+ | FirstName | LastName | …

mysql sorting unique database-table

vba: get unique values from array

Is there any built-in functionality in vba to get unique values from a one-dimensional array? What about just getting rid …

vba algorithm excel unique

Getting unique items from a list

What is the fastest / most efficient way of getting all the distinct items from a list? I have a List&…

c# list unique

Find unique lines

How can I find the unique lines and remove all duplicates from a file? My input file is 1 1 2 3 5 5 7 7 I would …

linux sorting unique uniq