This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I got an alerts table that contains alerts recived by servers the columns are: serverip, time stamp,alert type. I would like to get a list of all alerts but if two alerts have the same ip and type - i want to check thier time stamp and only if alert a.timestame >alertb.timestamp + 60 sec - i want to see both of them otherwise only one of then should be returned from the query(the newer one). will be happy to see some complex examples of ejb ql. thanks liat