question about the query..

Hi List I have a question regarding a SQL query I am working on. I have a table named 'tmp_scores', with a column 'rank' and other columns. Rank varies from 1 to 12. I need to get the top 10 million records based on the rank. I have used the logic behind the following query(to get top 4

RE: question about the query..

There are 43 million records in the table. I did the explain plan .Is there any mistake with the query. thanks srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: question about the query..

I am using the oracle 8.1.7.0. thanks srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: FROM SRINIVAS -HELP

Sorry list, I sent the following to the list by mistake. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

RE: !! Keeping the list alive

what man what else? are U leaving the office? ekkada work vachi potundhi. madala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: FROM SRINIVAS -HELP

Thanking U a lot . I will try on it. Thanks srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

FROM SRINIVAS -HELP

I have 44 million records in my table.I need to extract the 10 million records randomly,how to retrieve these records randomly. I used the dbms_random.sql ,but I have a doubt that I was correct or not. can U please guide me or just send a piece of code. Thanking U srinivas -- Please see the