python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - distinct-on

PostgreSQL SELECT result with a distinct ids that prefers specific values from another table

I have a some_dictionary table and a some_dictionary_language table with data in multiple languages(and a reference to some_dictionary). I need to get unique values on some_dictionary.id preferring th...
test-img

bezdroznik

postgresql

select

unique

distinct

distinct-on

Votes: 0

Answers: 1

Latest Answer

The ORDER BY that determine how the DISTINCT ON selects its record should be on the same level as the DISTINCT ON itself, not in a subquery. If you did that, the error message would tell you the probl...
test-img

jjanes

How to pull max timestamp for distinct sets and subsets

EDIT: DBMS = Haddoop, Using Teradata SQL Asstistant This is the original table. There are 20 location values (c1). Each Location has a set of aisles (c2). I want to get all the set of records from thi...
test-img

Number1Rock

sql

teradata

common-table-expression

distinct-values

distinct-on

Votes: 0

Answers: 2

Latest Answer

You didn't mention which DBMS you're using, but most databases support Window Functions. For example, with SQL Server you can assign a ROW_NUMBER() by Location and Aisle group, sorting by the latest T...
test-img

SOS

Typeorm order by after distinct on with postgresql

I have a table below: id product_id price  1 1 100 2 1 150 3 2 120 4 2 190 5 3 100 6 3 80 I want to select cheapest price for product and sort them by price Expected output: ...
test-img

I.Bozcan

postgresql

sql-order-by

distinct

typeorm

distinct-on

Votes: 0

Answers: 1

Latest Answer

SELECT id, product_id, price FROM (SELECT id, product_id, price, Dense_rank() OVER ( partition BY produ...
test-img

rajorshi

Posts

Questions

Blogs

Jobs