Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic 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

Related Hot Questions

Government Jobs Opening