Monday, January 21, 2008

SQL Server SELECT TOP x equivalent in ORACLE

No commet !

SQL Server:
SELECT TOP 10 * FROM myTable

ORACLE:
SELECT * FROM myTable WHERE ROWNUM <= 10

MySQL:
SELECT * FROM myTable LIMIT 10

No comments:

Shared Cache - .Net Caching made easy

All information about Shared Cache is available here: http://www.sharedcache.com/. Its free and easy to use, we provide all sources at codeplex.

Facebook Badge