ROWNUM. can anybody clarify this to me.

HI,

I have some basic doubts with the usage of ROWNUM.

I generally used to append a condition
  WHERE rownum = 1
for the SQL statements that check for the existence of a record.

Does this stmt get all the records that satisfy the condition before rownum = 1 and then use this condition or the first instance itself it gets only one record ?

Thanks for clarifying this to me.

laxmi. Received on Wed Aug 30 1995 - 00:00:00 CEST