Only Coders - Where knowledge meets opportunity

python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - distinct

Get distinct values within time chunks

I have a table with different species and their occurences (timestamp) from field survey: species | timestamp A | 2021-04-01T12:35 A | 2021-04-01T12:36 B | 2021-04-01T12:36 A |...

EndorCartographer

sql

sqlite

timestamp

distinct

timespan

Votes: 0

Answers: 1

Latest Answer

Use datetime function strftime() to produce the chunks: SELECT DISTINCT strftime( '%Y-%m-%dT%H:%M', timestamp, '-' || CASE WHEN timestamp LIKE '%0' THEN 9 ELSE SUBS...

forpas

MySQL Update Table 1 when LEFT JOIN table contains multiple matches per row

I have two tables that are joined on a command column. I need to update table 1 where an item in table 2 has multiple matches for the id. Table 1 items: +-------------------+------------------+------...

syntax

mysql

join

count

distinct

Votes: 0

Answers: 1

Latest Answer

You can't use an aggregation function in WHERE, because aggregation doesn't happen until after you select rows. Join with a subquery that only returns the rows with multiple matches. UPDATE items AS i...

Barmar

Running Total OVER clause, but Select Distinct instead of sum?

Samantha Valley

sql

distinct

window-functions

partition

Votes: 0

Answers: 3

Latest Answer

One way would be to cross-join the results and filter the joined table having a total <= to the running total: with counts as ( select *, Count(*) over (order by SIGNUP_DATE asc) as tot ...

Stu

DISTINCT but not really

Jakub Bednarski

mysql

sql

distinct

Votes: 0

Answers: 1

Latest Answer

You can use aggregation with max() (or min()) here, since NULLs aren't greater than, nor equal, nor less than any other value. SELECT data1, data2, data3, data4, max(import...

sticky bit

Posts

Questions

Blogs

Jobs

Questions about distinct

Read more about distinct