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
1908Post New Flextronics Business Objects Interview Questions
Explain Drawbacks of mobile banking?
How to interact with drupal search system?
What is the difference between model based testing and state transition testing? Or are they the same?
Which commands are included in ‘filtering results’ category?
Which is the best institute in hyderabad to learn CS?
If oil and air can withstand a high MeV when used as an insulator in a transformer, what are the values of how high for each material?
What are the different authentication modes in sql server? How can it be changed?
What are the characteristic of unitary political science?
what is operational data and operational system? : Sas-di
How Recall and True positive rate are related?
What is view? Different types of view.
What are the drawbacks of reflection?
How do I restore my wordpress theme?
In a SRAM layout, which metal layers would you prefer for Word Lines and Bit Lines? Why?
Is react a mvc framework?