Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
#Format : LIMIT s-1, t - (s - 1) SELECT ROUND(ABS(x1 - x2) + ABS(y1 - y2), 4) FROM (SELECT MIN(lon) x1, MAX(lon) x2 FROM (SELECT*FROM citytable WHERE lat < 121.8 ORDER BY lat DESC LIMIT 3, 15) AS Table1) AS latTable, (SELECT MIN(lat) y1, MAX(lat) y2 FROM (SELECT*FROM citytable WHERE lon > 25.1 ORDER BY lon ASC LIMIT 3, 15) AS Table2) AS lonTable;
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
