distinct Archives - IT Nursery

performance, Programming

IT Nursery

postgresql COUNT(DISTINCT …) very slow

I have a very simple SQL query: SELECT COUNT(DISTINCT x) FROM table; My table has about 1.5 million rows. This query is running ...

May 28, 2022
0 Comments

C#, Programming

IT Nursery

Get a list of distinct values in List

In C#, say I have a class called Note with three string member variables. public class Note { public string Title; public string ...

May 27, 2022
0 Comments

Count the occurrences of DISTINCT values

I am trying to find a MySQL query that will find DISTINCT values in a particular field, count the number of occurrences of ...

May 21, 2022
0 Comments

Select unique or distinct values from a list in UNIX shell script

I have a ksh script that returns a long list of values, newline separated, and I want to see only the unique/distinct values. ...

May 17, 2022
0 Comments

SQL to find the number of distinct values in a column

I can select all the distinct values in a column in the following ways: SELECT DISTINCT column_name FROM table_name; SELECT column_name FROM table_name ...

May 8, 2022
0 Comments

SQL/mysql – Select distinct/UNIQUE but return all columns?

SELECT DISTINCT field1, field2, field3, ...... FROM table I am trying to accomplish the following sql statement but I want it to return ...

May 6, 2022
0 Comments

How do I (or can I) SELECT DISTINCT on multiple columns?

I need to retrieve all rows from a table where 2 columns combined are all different. So I want all the sales that ...

May 4, 2022
0 Comments