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
1275Post New Flextronics Business Objects Interview Questions
- Flextronics C Interview Questions (1)
- Flextronics OOPS Interview Questions (1)
- Flextronics C++ General Interview Questions (2)
- Flextronics SQL Server Interview Questions (4)
- Flextronics DB Development Interview Questions (1)
- Flextronics SQL PLSQL Interview Questions (2)
- Flextronics Windows AllOther Interview Questions (1)
- Flextronics Operating Systems General Concepts Interview Questions (2)
- Flextronics Manual Testing Interview Questions (3)
- Flextronics Core Java Interview Questions (14) Flextronics Business Objects Interview Questions (1)
- Flextronics Informatica Interview Questions (3)
- Flextronics ETL Interview Questions (1)
- Flextronics HR Questions Interview Questions (14)
- Flextronics OOAD Interview Questions (1)
- Flextronics AI Algorithms Interview Questions (1)
- Flextronics Civil Engineering Interview Questions (2)
- Flextronics Electrical Engineering Interview Questions (1)
- Flextronics Electronics Communications Interview Questions (2)
- Flextronics Aeronautical Engineering Interview Questions (2)
- Flextronics Automobile Engineering Interview Questions (1)
- Flextronics Accounting AllOther Interview Questions (2)
- Flextronics BSRB AllOther Interview Questions (1)
- Flextronics Placement Papers Interview Questions (3)
What is a pipette and how is it used?
If we want to upload data through DataLoader, what the changes to be done?
What is Trigger in Oracle?
details of siemens automation systems.
Is react a library or a framework?
What does it indicate if an error state this “list has no rows for assignment”?
What is a view cursor?
Which is the class in java?
why we need to take u?
How to indentify MS-Word objects like Menubar, Toolbar, table/columns/rows/cells etc within Word document, using QTP?
what is the technology used in financial applications?
What is a service provider laravel?
What are service users?
How to use the Lookup method to return values from multiple columns ?
What are the different types of infocube?
