Ygthkb

Do orbiting planets have infinite energy?

No option to ask a question in https://developer.salesforce.com discussion forums

Other than edits for international editions, did Harry Potter and the Philosopher's Stone receive errata?

Why did Luke use his left hand to shoot?

How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?

Is it really OK to use "because of"?

How can I deduce the power of a capacitor from its datasheet?

Why is "rm -r" unable to delete this folder?

Is the symmetric product of an abelian variety a CY variety?

Why do objects rebound after hitting the ground?

Is the fingering of thirds flexible or do I have to follow the rules?

How do dictionaries source attestation

Taking an academic pseudonym?

Modern Algebraic Geometry and Analytic Number Theory

How does a Warlock with Pact of the Blade visually appear to fight?

Why do neural networks need so many examples to perform?

How long has this character been impersonating a Starfleet Officer?

Renting a 2CV in France

Do we still track damage on indestructible creatures?

Why is it that Bernie Sanders is always called a "socialist"?

Coworker asking me to not bring cakes due to self control issue. What should I do?

Equivalent of "illegal" for violating civil law

Solving the linear first order differential equation?

Boss asked me to sign a resignation paper without a date on it along with my new contract

Check if a column's values are increasing per tuple

Efficiently select beginning and end of multiple contiguous ranges in Postgresql queryConstraint exclusion to fetch latest N rowsHow to access NEW or OLD field given only the field's name?Getting around the constraint “column must appear in the GROUP BY clause or be used in an aggregate function”How do you concatenate JSONB columns in a PostgreSQL query to produce a JSONB object?Equivalent to PostgreSQL's Dollar-quoted String Constants for SQL ServerHow to pass a set or unnamed relation into a PostgreSQL function?How to run a dynamic select query with column names from another query?Show rows with non-unique value in one fieldMerge 2 columns and replace with specific output

0

I have a relation:

A(id INT, name STRING, time INT, val INT)

1   a   1   1

1   a   2   2

2   b   1   1

2   b   2   3

3   b   1   1

3   b   2   1

and so on. I want to output the id and name of 1 and 2, because their val of a tuple at time 1 is lesser than the val of the tuple at time 2. I'm completely stumped here. I can't give an attempt example because I don't know how to compare a tuple sequentially.

postgresql

share

asked 3 mins ago

Charlie BakerCharlie Baker

1

New contributor

Charlie Baker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have a relation:

A(id INT, name STRING, time INT, val INT)

1   a   1   1

1   a   2   2

2   b   1   1

2   b   2   3

3   b   1   1

3   b   2   1

and so on. I want to output the id and name of 1 and 2, because their val of a tuple at time 1 is lesser than the val of the tuple at time 2. I'm completely stumped here. I can't give an attempt example because I don't know how to compare a tuple sequentially.

postgresql

share

asked 3 mins ago

Charlie BakerCharlie Baker

1

New contributor

Charlie Baker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have a relation:

A(id INT, name STRING, time INT, val INT)

1   a   1   1

1   a   2   2

2   b   1   1

2   b   2   3

3   b   1   1

3   b   2   1

and so on. I want to output the id and name of 1 and 2, because their val of a tuple at time 1 is lesser than the val of the tuple at time 2. I'm completely stumped here. I can't give an attempt example because I don't know how to compare a tuple sequentially.

postgresql

share

asked 3 mins ago

Charlie BakerCharlie Baker

1

New contributor

Charlie Baker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

A(id INT, name STRING, time INT, val INT)

1   a   1   1

1   a   2   2

2   b   1   1

2   b   2   3

3   b   1   1

3   b   2   1

share

asked 3 mins ago

Charlie BakerCharlie Baker

1

New contributor

Charlie Baker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 3 mins ago

Charlie BakerCharlie Baker

1

New contributor

Charlie Baker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 mins ago

Charlie BakerCharlie Baker

1

New contributor

Charlie Baker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 mins ago

Charlie BakerCharlie Baker

1