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
#16 first 3 character of nth smallest/largest country and its cities SELECT SUBSTR(country, 1, 3), COUNT(city) Cities FROM citytable GROUP BY country ORDER BY Cities ASC LIMIT 1, 1; #17 Delete data where name of city starts or ends with specified character or lat/lon between some values DELETE FROM citytable WHERE city RLIKE "[nugi]$" OR city RLIKE "^[^wx]" OR lat BETWEEN 121.5 AND 125.5 AND lon BETWEEN 25.3 AND 25.5; #18 Swap(lat, lon) if last number of ID is m UPDATE citytable SET lat = lat + lon, lon = lat-lon, lat = lat - lon WHERE id % 10 = 4; #19 Euclidean distance between smallest lat, lon and largest lat, lon SELECT ROUND(SQRT(POW(MAX(lat) - MIN(lat), 2) + POW(MAX(lon) - MIN(lon), 2)), 4) FROM citytable;
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)
