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
1947Post New Flextronics Business Objects Interview Questions
Does eukaryotes have restriction modification system?
Explain the difference between gen1 and gen2 hadoop with regards to the namenode?
Who are the competitors of TCS in the world market as well as in Indian market?
Name the most common input formats defined in hadoop?
Tell me what is the limitation to the depth of your categories?
Why sap hana is used?
What is the Memorandum voucher?
What is accounting for transfers and terminations?
Tell me set-user-id is related to (in unix)?
What does it mean to call someone a tomcat?
Draw a flow chart and write a program for the difference between the sum of elements with odd and even numbers. Two dimensional array.
How to Perform Input/Output of Datagrams?
What are the different types of reports in salesforce ?
what is the format specifier for printing a pointer value?
What is c variable?