Reposted from: longtang Bay
1.1.1 obtain the first N records
SQL Server: Select Top N * From xtable
ORACLE: Select * From xtable where rownum
DB2: Select * From xtable fetch first n rows only
1.1.2 obtain the current date
SQL Server: Select getdate
Brief introductionWhen it comes to ensuring that enterprise applications built with IBM DB2 (DB2 certified DB2 Training) ®universal Database "(DB2 UDB) and borland® tools (such as Delphi, C++builder, or Kylix) have the best performance, programmers
DB2 Date Time function(DATE (TRIM (CHAR (dt#11y)) | | -' | | TRIM (CHAR (dt#11m)) | | ' -' | | TRIM (CHAR (dt#11d))) between date (' & StrDate1 & ') and date (' & StrDate2 & '))(Y > Y) or ((y = y) and (M > m)) or ((y = y) and (M = m) and (d >=
Author: (US) Tony Andrews Translator: Chen Yong Yang Health Series name: Chapter Hua programmer library Publishing House: Machinery Industry Publishing House ISBN: 9787111425021 shelving time: -6-4 published on: July 4,: 16 webpage: 86 versions: 1-1
1. Combined statement execution
Begin atomic
Expression 1, semicolon, space, and carriage return
Expression 2; semicolon (,), space, and carriage return
End
2. Tables with limited access permissions (the Public select access permission for
DB2 Vs MySQL series | comparison of data types between MySQL and DB2, db2mysql
As MySQL Databases become more and more widely used, there are more and more demands for migration from DB2 to MySQL databases. During database migration, the first
Comparison | program
Brief introduction
In the view of. NET application developers, using DB2 is no different from using any other relational database. You can see countless examples of using SQL Server and Oracle products to perform database tasks,
TurnRecently in see DB2, read while writing some, write down, although write a mess. For later use.These are all very simple to write. I think it is some simple operation, and some are excerpted from other people's blog specific is to cite which is
DB2 supports the following two types of tablespaces:1. System Management Memory table space (Sms-system MANAGED STORAGE)2. Database Management Memory table space (Dms-database MANAGED STORAGE)Comparison of characteristics of SMS and DMS user table
The difference between DB2 and Oracle
1, DB2 access to the first 10 lines of data and Oracle Difference
DB2:
SELECT * FROM Test fetch a
Oracle:
SELECT * FROM Test where rownumQuery statement
DB2: Do not provide stealth conversion
SELECT * from
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.