(tag data are marked in green)
Reading tag COLUMN1@alias:
|
ID |
COLUMN1 |
COLUMN2 |
COLUMN3 |
|
1 |
11 |
12 |
13 |
|
2 |
21 |
22 |
23 |
|
3 |
31 |
32 |
33 |
|
4 |
41 |
42 |
43 |
|
5 |
51 |
52 |
53 |
Reading tag COL[1]@alias:
|
ID |
COLUMN1 |
COLUMN2 |
COLUMN3 |
|
1 |
11 |
12 |
13 |
|
2 |
21 |
22 |
23 |
|
3 |
31 |
32 |
33 |
|
4 |
41 |
42 |
43 |
|
5 |
51 |
52 |
53 |
Reading tag COLUMN2[5]@alias:
|
ID |
COLUMN1 |
COLUMN2 |
COLUMN3 |
|
1 |
11 |
12 |
13 |
|
2 |
21 |
22 |
23 |
|
3 |
31 |
32 |
33 |
|
4 |
41 |
42 |
43 |
|
5 |
51 |
52 |
53 |
Reading tag COLUMN3[ID>2]@alias:
|
ID |
COLUMN1 |
COLUMN2 |
COLUMN3 |
|
1 |
11 |
12 |
13 |
|
2 |
21 |
22 |
23 |
|
3 |
31 |
32 |
33 |
|
4 |
41 |
42 |
43 |
|
5 |
51 |
52 |
53 |
Reading tag ROW[1]@alias:
|
ID |
COLUMN1 |
COLUMN2 |
COLUMN3 |
|
1 |
11 |
12 |
13 |
|
2 |
21 |
22 |
23 |
|
3 |
31 |
32 |
33 |
|
4 |
41 |
42 |
43 |
|
5 |
51 |
52 |
53 |
Reading tag ROW[COLUMN1=31]@alias:
|
ID |
COLUMN1 |
COLUMN2 |
COLUMN3 |
|
1 |
11 |
12 |
13 |
|
2 |
21 |
22 |
23 |
|
3 |
31 |
32 |
33 |
|
4 |
41 |
42 |
43 |
|
5 |
51 |
52 |
53 |
- Note: Access to Oracle, PostgreSQL, and MySQL databases uses a native driver provided by the corresponding companies.
- Tip: You can have multiple connections to single or even multiple databases. This way you can use multiple tables and optimize your queries.