Mark W the SQL Geek

Opinions, experiences and information about SQL and the databases that process the language, from a guy who's been at it for over 20 years.

Sunday, August 22, 2010

Oww...My Brain!

http://thedailywtf.com/Articles/A-Confusing-SELECTion.aspx

No need for further comment.
on August 22, 2010 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Pages

  • Home
  • Privacy Policy
  • Cookie Policy

About Me

My photo
MWrynn
Self-proclaimed SQL geek whose career has largely focused on SQL, and the database software that processes the language, in one form or another since 2003. Motto: "When in doubt, test it out."
View my complete profile

Blog Archive

  • ►  2025 (6)
    • ►  August (1)
    • ►  July (1)
    • ►  May (4)
  • ►  2024 (5)
    • ►  December (2)
    • ►  September (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2023 (3)
    • ►  November (3)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (3)
    • ►  August (2)
    • ►  January (1)
  • ►  2019 (9)
    • ►  October (1)
    • ►  June (4)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2018 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (3)
    • ►  August (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2017 (6)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
  • ►  2016 (17)
    • ►  November (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (1)
    • ►  April (2)
    • ►  March (4)
    • ►  February (3)
    • ►  January (1)
  • ►  2015 (11)
    • ►  December (1)
    • ►  May (1)
    • ►  March (5)
    • ►  February (4)
  • ►  2014 (8)
    • ►  September (1)
    • ►  August (2)
    • ►  March (3)
    • ►  February (2)
  • ►  2013 (12)
    • ►  December (1)
    • ►  November (3)
    • ►  September (2)
    • ►  August (2)
    • ►  April (1)
    • ►  March (3)
  • ►  2012 (4)
    • ►  August (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2011 (24)
    • ►  December (1)
    • ►  November (3)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  May (3)
    • ►  April (3)
    • ►  March (2)
    • ►  February (2)
    • ►  January (2)
  • ▼  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ▼  August (1)
      • Oww...My Brain!
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2009 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2008 (1)
    • ►  December (1)
  • ►  2007 (6)
    • ►  July (2)
    • ►  May (1)
    • ►  April (3)

Labels

  • 10
  • 11g
  • 12c
  • 12cR2
  • add column
  • alert log
  • Amazon
  • analytics
  • ANSI
  • apgdiff
  • api
  • argh
  • AskTom
  • auditing
  • awesome
  • AWS
  • big data
  • bind
  • bind variables
  • bonkers
  • BoobyTrap
  • Books
  • bug
  • caching
  • cartoon
  • cern
  • character sets
  • chat
  • clone
  • cluster
  • clustered
  • clustering
  • collations
  • column
  • column store
  • columns diffs
  • common table expressions
  • comparison
  • connor mcdonald
  • constructing rows
  • crazy
  • CTE
  • CTEs
  • danger
  • database of the year
  • db-engines
  • db2
  • ddl
  • default
  • diff
  • distinct on
  • dynamic columns
  • EC2
  • emacs
  • errors
  • evil
  • Evil MySQL Feature
  • example
  • expdp
  • export
  • features
  • foreign keys
  • game
  • generate series
  • generation
  • history
  • IGNORE
  • impdp
  • import
  • in
  • incremental refresh
  • independence
  • index
  • indexes
  • inheritance
  • INSERT IGNORE
  • installation
  • ISO
  • Java
  • JDBC
  • join
  • joins
  • JOOQ
  • JSON
  • just bind
  • key-value
  • length
  • limitation
  • linux
  • lisp
  • load balancing
  • locking
  • locks
  • logging
  • mandelbrot
  • maria
  • mariadb
  • MATCH_RECOGNIZE
  • materialized views
  • merge
  • microsoft
  • MODIFY
  • MS SQL
  • MSSQL
  • mwrynn
  • MySQL
  • MySQL.com
  • newlines
  • News
  • numeric
  • odd
  • online recovery
  • optimization
  • optimizations
  • optional
  • oracle
  • parallel
  • parameter
  • parameterization
  • parameters
  • paramterization
  • partitioned aggregates
  • partitioning
  • performance
  • pgpool
  • pgpool-ii
  • pi
  • pi day
  • pivot
  • pl/sql
  • postgres
  • postgresql
  • preparedstatement
  • query
  • query rewrite
  • quiz
  • random
  • rant
  • RDS
  • recovery
  • recursive
  • recursive query
  • reddit
  • reference
  • refresh
  • release
  • REPLACE
  • REPLACE INTO
  • reporting
  • retrosheet
  • rewrite
  • row
  • row constructor
  • row pattern matching
  • schema
  • scripts
  • sequences
  • series
  • shared memory
  • shmmax
  • sparkfun
  • speed
  • SQL
  • SQL injection
  • SQL Server
  • sqlplus
  • standard SQL
  • sucks
  • Sybase
  • syntax
  • table
  • test
  • Tom Kyte
  • trick
  • unpivot
  • upgrade
  • upgrading
  • upsert
  • usebindvariables
  • value
  • version
  • versioning
  • weird
  • whygod
  • window
  • window functions
  • windowing
  • with
  • with recursive
  • wonky

Report Abuse

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Followers

Search This Blog

The LENGTH() function - or - SQL is SQL so it's all interchangeable am-I-right?

Popular Posts

  • The Benefits of Using Row Constructors! [MySQL]
      In the world of SQL, sometimes you need to conjure up rows of literal data out of thin air, instead of pulling data from an existing table...
  • Playing SQL Mythbuster - or - I really ought to lay off the SQL on social media
    Often, when I visit SQL-related forums and social media, I encounter posts that are half-truths, overgeneralizations, and sometimes, outrigh...
  • Pgpool-II Load Balancing
    NOTE: this post is surely hopelessly out of date. It is from 2011! I say this because the post is still getting views well over a decade lat...
Watermark theme. Powered by Blogger.