Home » Developer & Programmer » Forms » to select best two from three quizez and the find its avaerage (orcle 8.1.7 and Developer 6)
to select best two from three quizez and the find its avaerage [message #346783] Tue, 09 September 2008 12:54 Go to next message
orarep
Messages: 56
Registered: September 2007
Member
hi

i have tabular form and it contains four coloumns. i.q quiz1_marks,quiz2_marks,quiz3_marks and Total.

what i want is that student obrain marks in each quiz and then form automatically select best two quizez and then find it avaerage and put it in Total coloumns using any event like key-next-item etc.

i tried to use analytical function but i couldn't.

any can help plz, any idea


regards


orarep
Re: to select best two from three quizez and the find its avaerage [message #346822 is a reply to message #346783] Tue, 09 September 2008 15:51 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Search the OraFAQ site (not only the Forum) for the "top n" queries (as you need "top 2 marks").
Previous Topic: Icons are not showing on client pc in forms 10g application
Next Topic: Message "Do you want to save change you have made?
Goto Forum:
  


Current Time: Wed Dec 07 11:01:27 CST 2016

Total time taken to generate the page: 0.08522 seconds