Timeline for SQL select number ranges
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 30, 2017 at 22:33 | comment | added | Peter Taylor |
@BradC, or SELECT DISTINCT(number+2)... WHERE number<19
|
|
| Jun 30, 2017 at 21:33 | comment | added | BradC | Yep you either need to use DISTINCT or use WHERE type='P'. Distinct is slightly shorter. | |
| Jun 30, 2017 at 21:06 | history | edited | Oliver | CC BY-SA 3.0 |
deleted 6 characters in body
|
| Jun 30, 2017 at 20:55 | history | edited | Oliver | CC BY-SA 3.0 |
deleted 3 characters in body
|
| Jun 30, 2017 at 20:47 | history | edited | Oliver | CC BY-SA 3.0 |
added 183 characters in body
|
| Jun 30, 2017 at 20:40 | comment | added | Oliver | @MagicOctopusUrn Because there are duplicate numbers in that table. | |
| Jun 30, 2017 at 20:38 | comment | added | Magic Octopus Urn | Why do you use distinct? Seems redundant. | |
| Jun 30, 2017 at 19:24 | comment | added | BradC |
For golfing you save 2 bytes with WHERE number>0AND number<21
|
|
| Jun 30, 2017 at 19:08 | history | edited | Oliver | CC BY-SA 3.0 |
added 134 characters in body
|
| Jun 30, 2017 at 18:59 | history | answered | Oliver | CC BY-SA 3.0 |