Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I calculate Ratio using SQL?

468665Nov 28 2006 — edited Nov 28 2006
Hi Friends,

I have table STUDENT with fields ROLL NO., NAME, AGE and SEX.
Table has 300 rows of students having SEX Males and Females,
How can I calculate ratio of Male and Female students from 300 records?

Ratio calculation is as, if there 200 Male and 100 Female out of 300 students, then Ratio between Male and Female is 2:1.

So kindly send me the code in SQL>, on urgently basis.

Best Regards,


Shahzad
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2006
Added on Nov 28 2006
5 comments
4,875 views