Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


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
28 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...