176
176
select abs(-2) * -2;
179
CREATE TABLE t1 (a INT);
180
INSERT INTO t1 VALUES (1),(1),(1),(2);
181
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1;
182
RAND(2) * 1000 RAND(a) * 1000
183
655.586646549019 405.403537121977
184
122.346619258026 405.403537121977
185
644.97318737672 405.403537121977
186
857.826109843167 655.586646549019
187
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1 WHERE a = 1;
188
RAND(2) * 1000 RAND(a) * 1000
189
655.586646549019 405.403537121977
190
122.346619258026 405.403537121977
191
644.97318737672 405.403537121977
192
INSERT INTO t1 VALUES (3);
193
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1;
194
RAND(2) * 1000 RAND(a) * 1000
195
655.586646549019 405.403537121977
196
122.346619258026 405.403537121977
197
644.97318737672 405.403537121977
198
857.826109843167 655.586646549019
199
354.211017819318 905.76975597606
200
SELECT RAND(2) * 1000, RAND(a) * 1000 FROM t1 WHERE a = 1;
201
RAND(2) * 1000 RAND(a) * 1000
202
655.586646549019 405.403537121977
203
122.346619258026 405.403537121977
204
644.97318737672 405.403537121977
206
179
select round(111,-10);