questions - Question:SQL, How to get the year that an event occurs for the second time


If we have data like this:
Elem1 2012
Elem1 2013
Elem1 2015
Elem2 2012
Elem2 2013
Elem3 2012
And an element fails when there are 2 occurrences, how do I get the fail year for each failing element using transact SQL?
Elem1 2013
Elem2 2013

asked Sep 13, 2013 in Java Interview Questions by rajesh
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.