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
1880Post New Flextronics Business Objects Interview Questions
How many maximum threads can you create?
Describe the mknod command and when you’d use it.
how to fix an android application crash? How to analyze a crash using logcat?
please tell me wat types of technical questions will be asked in Alcatel lucent. and suggest me which site to view
What is a type in swift?
What is a Blob?
Which cryptographic algorithm is used in blockchain?
Explain when do we analyze the tables? How do we do it?
What is the use of ctrl q?
What are aggregate tables and aggregate fact tables?
What is “eucalyptus” in cloud computing? Why is it used?
What is a a tag?
What is a server easy definition?
Is ubuntu an open source operating system?
How do arrays work?