1 Replies - 1250 Views - Last Post: 30 August 2013 - 08:10 PM Rate Topic: -----

#1 mutmalar  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 17-June 13

Percentage calculation

Posted 12 August 2013 - 10:09 PM

I have MS Access table namely 'Merit' having field with Regno, Name, DOB, maths, Physics, Chemistry, Biology, Computer. I have taken Maths and Physics are compulsory subject for calculation and third subject is optional subject i.e Whose student secure highest mark either in chemistry or Biology or Computer taken for calculation.

How to write sql Query?
Is This A Good Question/Topic? 0
  • +

Replies To: Percentage calculation

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Percentage calculation

Posted 30 August 2013 - 08:10 PM

Look at the SWITCH function along with the TOP statement and order by descending.

This post has been edited by BobRodes: 30 August 2013 - 08:25 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1