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
No Answer is Posted For this Question
Be the First to Post Answer
What is thumbnail?
Difference between Decode and Case?
8 Answers Polaris, TCS, Wipro,
please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
Can anybody tell me about issues faced while creating universe. thanks in advance
What is meant by ZABO and FC(full-client)?
Hi any done business objects certification.i am expecting some help from them.
disadvantages of boxi
how do we apply sql query on selected variables?
Explain what are the measure objects?
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....