Select rows with different values on different columns

Question

I'm new to SQL so this took my a long time without being able to figure it out. My table looks like this:

+------+------+------+
|ID    |2016  | 2017 |
+------+------+------+
|1     |A     |A     |
+------+------+------+
|2     |A     |B     |
+------+------+------+
|3     |B     |B     |
+------+------+------+
|4     |B     |C     |
+------+------+------+

I would like to have only the rows which have changed from 2016 to 2017:

+------+------+------+
|ID    |2016  | 2017 |
+------+------+------+
|2     |A     |B     |
+------+------+------+
|4     |B     |C     |
+------+------+------+

Could you please help ?

This question has a pretty basic SQL solution that is already posted below. However, for clarity, what database client are you using? — SandPiper
– SandPiper, Commented Jun 17, 2017 at 21:46
Just an FYI – I updated the question to remove the Essbase tag. You probably have Essbase in your environment somewhere, but this is actually the relational database (SQL Server, Oracle relational) side of things — jwj
– jwj, Commented Jun 20, 2017 at 16:45

Nad · Accepted Answer · 2017-06-16 23:49:52Z

3

select * from mytable where column_2016<>column_2017 assuming your column labels are column_2016 and column_2017

answered Jun 16, 2017 at 23:49

Nad

5565 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select rows with different values on different columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related