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
1542Post New Flextronics Business Objects Interview Questions
What are the data types in oracle?
Write down the benefits of php7?
When we can update the application? Is server up time or downtime?
How to find flanking region ?
What are acid properties of transaction?
How do you sort in descending order in java using collections sort?
which are the sizes of capsules?
Where is registry stored?
How to import rules using pzinskey?
Why was xml developed?
how technical is calculated in 11kv line and lt line
What is the reason for emitting the white exhaust smoke during start of the vehicle?
How to calculate the area of a irregular sized land in square feet?and what will be the total area of this land South-51.1ft , North-47.7ft , East-53.3ft , West-54ft ?please explain me how to calculate?
Explain the Types of inheritances in django ?
Is ajax an api?