Bisa dilihat disini jawabannya.

http://www.oracle.com/technology/oramag/oracle/06-sep/o56asktom.html


Salam,

Indra Armansyah
[EMAIL PROTECTED]

  ----- Original Message ----- 
  From: abang sunda 
  To: [email protected] 
  Sent: Wednesday, March 14, 2007 1:40 PM
  Subject: [indo-oracle] [ask] query rownum


  all,

  mo tanya kenapa query

  select column1, rownum from table ;
  mempunyai hasil

  tetapi
  select column1, rownum from table WHERE ROWNUM > 1;

  selalu now rows selected ?

  terima kasih

  __________________________________________________________
  Don't pick lemons.
  See all the new 2007 cars at Yahoo! Autos.
  http://autos.yahoo.com/new_cars.html 


   


------------------------------------------------------------------------------


  No virus found in this incoming message.
  Checked by AVG Free Edition.
  Version: 7.5.446 / Virus Database: 268.18.11/721 - Release Date: 3/13/2007 
4:51 PM


[Non-text portions of this message have been removed]

Kirim email ke