blob: 346816b157a11f5aaa6ed1b0425e6d06b65656d5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
QUERY: SELECT DISTINCT two FROM temp;
two
---
0
1
(2 rows)
QUERY: SELECT DISTINCT ten FROM temp;
ten
---
0
1
2
3
4
5
6
7
8
9
(10 rows)
QUERY: SELECT DISTINCT string4 FROM temp;
string4
-------
AAAAxx
HHHHxx
OOOOxx
VVVVxx
(4 rows)
QUERY: SELECT DISTINCT two, string4, ten
FROM temp
ORDER BY two using <, string4 using <, ten using <;
two|string4|ten
---+-------+---
0|AAAAxx | 0
0|AAAAxx | 2
0|AAAAxx | 4
0|AAAAxx | 6
0|AAAAxx | 8
0|HHHHxx | 0
0|HHHHxx | 2
0|HHHHxx | 4
0|HHHHxx | 6
0|HHHHxx | 8
0|OOOOxx | 0
0|OOOOxx | 2
0|OOOOxx | 4
0|OOOOxx | 6
0|OOOOxx | 8
0|VVVVxx | 0
0|VVVVxx | 2
0|VVVVxx | 4
0|VVVVxx | 6
0|VVVVxx | 8
1|AAAAxx | 1
1|AAAAxx | 3
1|AAAAxx | 5
1|AAAAxx | 7
1|AAAAxx | 9
1|HHHHxx | 1
1|HHHHxx | 3
1|HHHHxx | 5
1|HHHHxx | 7
1|HHHHxx | 9
1|OOOOxx | 1
1|OOOOxx | 3
1|OOOOxx | 5
1|OOOOxx | 7
1|OOOOxx | 9
1|VVVVxx | 1
1|VVVVxx | 3
1|VVVVxx | 5
1|VVVVxx | 7
1|VVVVxx | 9
(40 rows)
QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
age
---
98
88
78
68
60
58
50
48
40
38
34
30
28
25
24
23
20
19
18
8
(20 rows)
|
