teror Posted September 21, 2005 Report Share Posted September 21, 2005 Kā uz oracle izmantot kautko šitādu: SELECT id, name, date FROM table ORDER BY date DESC LIMIT 10 Link to comment Share on other sites More sharing options...
Delfins Posted September 21, 2005 Report Share Posted September 21, 2005 nav tādas iespējas DB līmenī... Bet ir iespēja php-oci-draivera līmenī ... http://lv.php.net/manual/en/function.oci-fetch-all.php Link to comment Share on other sites More sharing options...
Delfins Posted September 21, 2005 Report Share Posted September 21, 2005 (edited) Vai arī taisīt sub-query pēc kaut kāda countera (increment) select *, recNum from ( select *, ROWNUM as recNum from table ) where recNum > 0 AND recNum < 10 Edited September 21, 2005 by Delfins Link to comment Share on other sites More sharing options...
Recommended Posts