No commet !
SQL Server:
SELECT TOP 10 * FROM myTable
ORACLE:
SELECT * FROM myTable WHERE ROWNUM <= 10
SELECT * FROM myTable LIMIT 10
Roni Schuetz, a Swiss and Israeli national, is an IT project manager, enterprise architect and software engineer. He works as software engineer with over 18 years of professional experience with scripting and object-oriented languages on multiple platforms. Currently he is mainly focusing on RESTful (ROA) and Service (SOA) Oriented Architectures, Enterprise Software / Architecture and RESTful Web Services in the transportation industry.
No commet !
SQL Server:
SELECT TOP 10 * FROM myTable
ORACLE:
SELECT * FROM myTable WHERE ROWNUM <= 10
at 11:51 AM Posted by roni schuetz
Labels: code sample, MySql, Oracle, sql, SQL Server
No comments:
Post a Comment