SELECT price FROM history WHERE id <= 20 ORDER BY price; SELECT COALESCE(price, 0) AS price FROM history WHERE id <= 20 ORDER BY price;
price |
---|
null |
null |
null |
11.866840 |
165.719980 |
220.130140 |
255.304260 |
447.617910 |
555.924660 |
557.201690 |
592.212810 |
694.705850 |
720.863290 |
728.519790 |
758.528980 |
817.706430 |
855.565560 |
915.765130 |
935.217710 |
955.729040 |
price |
---|
0.000000 |
0.000000 |
0.000000 |
11.866840 |
165.719980 |
220.130140 |
255.304260 |
447.617910 |
555.924660 |
557.201690 |
592.212810 |
694.705850 |
720.863290 |
728.519790 |
758.528980 |
817.706430 |
855.565560 |
915.765130 |
935.217710 |
955.729040 |