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
1987Post New Flextronics Business Objects Interview Questions
Can we handle the error and redirect to some pages using web.config?
Is it possible to switch between recording modes during a test creation?
Explain how can one estimate how the friction factor changes in heat exchanger tubes with a change in temperature?
Does drop table remove indexes?
Why struct is used in c++?
How do I make my wordpress site visible?
What is dbcontext and dbset?
Do you have an idea about MFC?
Explain about accessibility modifier 'protected internal'?
What spring sub-projects do you know?
What are the implications of implementing database.stateful?
What is data bind in c#?
How long does hotfix for windows take to install?
How to use pagination in cakephp?
What are the matching criteria for incoming dial-peers and outgoing dial-peers in their order of preference?