|
0
|
1 * DB2
|
|
|
2 | SELECT x | db.Select(() => x) | #sql SELECT x \nFROM SYSIBM.SYSDUMMY1 \nFETCH FIRST 1 ROW ONLY
|
|
|
3 | TAKE x | query.Take(x) | #sql ... FETCH FIRST x ROWS ONLY
|
|
|
4
|
|
|
5 * Informix
|
|
|
6 | SELECT x | db.Select(() => x) | #sql SELECT FIRST 1 x\nFROM SYSTABLES
|
|
|
7 | TAKE x | query.Take(x) | #sql SELECT FIRST x
|
|
|
8
|
|
|
9 * Oracle
|
|
|
10 | SELECT x | db.Select(() => x) | #sql SELECT x \nFROM SYS.DUAL
|
|
|
11 | TAKE x | query.Take(x) | #sql ... WHERE rownum <= x
|
|
|
12
|
|
|
13 * Firebird
|
|
|
14 | SELECT x | db.Select(() => x) | #sql SELECT x \nFROM rdb$database
|
|
|
15 | TAKE x | query.Take(x) | #sql SELECT FIRST x
|
|
|
16
|
|
|
17 * PostgreSQL
|
|
|
18 | SELECT x | db.Select(() => x) | #sql SELECT x
|
|
|
19 | TAKE x | query.Take(x) | #sql ... LIMIT x
|
|
|
20
|
|
|
21 * MySql
|
|
|
22 | SELECT x | db.Select(() => x) | #sql SELECT x
|
|
|
23 | TAKE x | query.Take(x) | #sql ... LIMIT x
|
|
|
24
|
|
|
25 * MS SQL
|
|
|
26 | SELECT x | db.Select(() => x) | #sql SELECT x
|
|
|
27 | TAKE x | query.Take(x) | #sql SELECT TOP x
|
|
|
28
|
|
|
29 * SqlCe
|
|
|
30 | SELECT x | db.Select(() => x) | #sql SELECT x
|
|
|
31
|
|
|
32 * Sybase
|
|
|
33 | SELECT x | db.Select(() => x) | #sql SELECT x
|
|
|
34 | TAKE x | query.Take(x) | #sql SELECT TOP x
|
|
|
35
|
|
|
36 * SQLite
|
|
|
37 | SELECT x | db.Select(() => x) | #sql SELECT x
|
|
|
38 | TAKE x | query.Take(x) | #sql ... LIMIT x
|
|
|
39
|
|
|
40 * Access
|
|
|
41 | SELECT x | db.Select(() => x) | #sql SELECT x
|
|
|
42 | TAKE x | query.Take(x) | #sql SELECT TOP x
|
