TinyJava.Net
Wednesday, January 7, 2009
SQL SELECT TOP N equivalent in ORACLE and MySQL
SQL Server:
SELECT TOP 10 product, descr, email
FROM products
ORACLE:
SELECT product, descr, email
FROM products
WHERE ROWNUM <= 10
MySQL:
SELECT product, descr, email
FROM products
LIMIT 10
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Followers
TinyJava.NET Blog Archive
►
2011
(1)
►
December
(1)
▼
2009
(38)
►
October
(1)
►
May
(4)
►
April
(12)
►
March
(11)
►
February
(5)
▼
January
(5)
SQL SELECT TOP N equivalent in ORACLE and MySQL
cvs资源列表的head、branches、version、dates
WSDL starter
使用Eclipse的wsdl2java工具
axis的WSDL2java工具初识
►
2008
(7)
►
December
(7)
About Me
Unknown
View my complete profile
No comments:
Post a Comment