How do I use ROWNUM attribute?

[Cantor]

Hi, I think I wounder about nothing but how do I must use the <b>ROWNUM</b> attribute? I must list only the first two elements of a table and I must use <b>ROWNUM</b> but I found nothing on that.<br><br><u>Thanx!!</u>

 

[MikeLacey]

Cantor,<br><br>The rownum attribute can be selected as you would select any column in a table; but it's the row number of the table generated by the select statement - not the physical row number from the database...<br><br>The usual use of rownum is to pick out just the first few rows from a query, like this<br><br><FONT FACE=monospace><b><br>Select *<br>&nbsp;&nbsp;&nbsp;&nbsp;From EMP<br>&nbsp;&nbsp;&nbsp;&nbsp;Where ROWNUM &lt;4;<br></font></b><br><br>That will pick out the first three rows from that query.<br> <p>Mike<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Please don't send me email questions without posting them as well. Post the question and send me a note saying "Have a look at so-and-so would you?" - that's fine.