Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch 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



Government Jobs Opening


...