Model | year |
---|---|
Apple | 2009 |
Apple | 2010 |
HTC | 2010 |
Motorola | 2009 |
Motorola | 2010 |
Nokia | 2009 |
Nokia | 2010 |
One Plus | 2009 |
One Plus | 2010 |
Samsung | 2009 |
Samsung | 2010 |
how to get the model which is present in year 2010 but not in 2009. result should be |HTC| 2010|
Model | year |
---|---|
Apple | 2009 |
Apple | 2010 |
HTC | 2010 |
Motorola | 2009 |
Motorola | 2010 |
Nokia | 2009 |
Nokia | 2010 |
One Plus | 2009 |
One Plus | 2010 |
Samsung | 2009 |
Samsung | 2010 |
how to get the model which is present in year 2010 but not in 2009. result should be |HTC| 2010|
2条答案
按热度按时间rur96b6h1#
or
or
or
or
3pmvbmvn2#
You can do something like this:
This will return rows with Model that exist only once