What is a cross tab query and how do you create one using a relational database?
www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25
Saved 21 times on del.icio.us, most recently in 2012.
More links tagged sql
- ConnectionStrings.com - Forgot that connection string? Get it here! www.connectionstrings.com
- MySQL Cheat Sheet www.nparikh.org
- A Gentle Introduction to SQL sqlzoo.net
- Google Cloud SQL - Google Code code.google.com
- NOSQL Databases nosql-database.org
- Log Parser Plus - Log Parser Example Queries logparserplus.com
- Library of Free Data Models www.databaseanswers.org
- SQLite Home Page www.sqlite.org
- Sequel Pro โ MySQL database management app for Mac OS X www.sequelpro.com
- SQL Injection Attacks by Example www.unixwiz.net
More links tagged crosstab
- Roland Bouman's blog: Creating Crosstabs in MySQL rpbouman.blogspot.com
- Cross Tabs and Pivots, Part 1 โ Converting Rows to Columns - SQLServerCentral www.sqlservercentral.com
- Dynamic Cross-Tabs/Pivot Tables - SQLTeam.com www.sqlteam.com
- Creating cross tab queries and pivot tables in SQL www.simple-talk.com
- MySQL :: MySQL Wizardry dev.mysql.com
- MySQL :: MySQL Wizardry dev.mysql.com
- CrossTab Queries in PostgreSQL using tablefunc contrib - Postgres OnLine Journal www.postgresonline.com
- MySQL/Pivot table - Wikibooks, collection of open-content textbooks en.wikibooks.org
- Introduction to Dynamic SQL (Part 2) - SQLTeam.com www.sqlteam.com
- Another Dynamic SQL CrossTab Stored Procedure weblogs.sqlteam.com
More links tagged database
- The Internet Movie Database (IMDb) www.imdb.com
- Freebase www.freebase.com
- google-refine - Google Refine, a power tool for working with messy data (formerly Freebase Gridworks) - Google Project Hosting code.google.com
- Cube square.github.com
- allmusic www.allmusic.com
- WordPress Essentials: Interacting With The WordPress Database - Smashing WordPress wp.smashingmagazine.com
- ConnectionStrings.com - Forgot that connection string? Get it here! www.connectionstrings.com
- [WorldCat.org] Search for books, music, videos, articles and more in libraries near you www.worldcat.org
- MySQL Cheat Sheet www.nparikh.org
- Welcome to MusicBrainz! - MusicBrainz musicbrainz.org