I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
1984Post New Flextronics Business Objects Interview Questions
What is a graphic device?
Explain the extension .hta?
why is waterfall model not good?
Why is it important to be familiar with the laboratory apparatus and their uses?
What is difference between onload and ready?
What is the use of $locale service in angularjs?
What is the best tool for modeling and ORM framework
What is the use of @qualifier in spring?
What is t code for deadline monitoring?
What is primitive data type in java?
What is list when we have to use ?
What is the difference amongst jvm spec, jvm implementation, jvm runtime ?
How to call java method in jsp page on button click?
Differentiate “find a method” from “select method” in EJB ?
Revenue Expenditure