<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>Don't know if it is relevant to you, but I use Oracle and I've gotten burned by the limit a couple of times.<br>If you write something like:<br>select * from taxonomy where rownum < 10 order by tax_id <br><br>You do not get the first 10 rows, but a seemingly random 10 rows.<br>The first 10 requires a subquery, otherwise oracle sorts the rows after taking the first 10 rows, not before.<br><br>select * from (select * from taxonomy order by tax_id ) where rownum < 10 <br><br><br><br><br><hr id="stopSpelling">> Date: Tue, 24 Oct 2006 16:22:32 -0500<br>> To: austin@pm.org<br>> From: CaptNemo@Austin.rr.com<br>> Subject: Re: APM: Last question (for today)<br>> <br>> DOH, limit the SQL query.<br>> <br>> /me feels dumb.<br>> <br>> I was so caught up in the joy that my pages are working, I'm not thinking <br>> straight.<br>> <br>> <br>> <br>> >Use your databases limit feature. Often the word "LIMIT" followed by a<br>> >number at the end of the statement.<br>> ><br>> >example:<br>> ><br>> >SELECT *<br>> > FROM dual<br>> > LIMIT 1;<br>> <br>> _______________________________________________<br>> Austin mailing list<br>> Austin@pm.org<br>> http://mail.pm.org/mailman/listinfo/austin<br><br /><hr />Try the next generation of search with Windows LiveT Search today! <a href='http://search.live.com' target='_new'>Try it!</a></body>
</html>