Oracle Database Discussions

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!

50% rows of total records

548966Nov 29 2006 — edited Nov 30 2006

Hi Guys,

I want to find the 50% of records from the total rows. say My query returns 100 records then I need 50 records out of that. In my sql there are multiple joins are there.

How can achive this?? Pls. help.

Thanks & Regards
Pravat Choudhury

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2006

Added on Nov 29 2006

#general-database-discussions

16 comments

811 views