S p o r t s D a t a B a s e . c o m
a sports data query language (SDQL ©) consultancy

Permission is given to quote trends found on SportsDataBase.com provided that a reference and a link to SportsDataBase.com is provided. E.g.: Trend found on SportsDataBase.com


Winning Picks, Guaranteed
TOC  |  Introduction  |  Basics  |  Prefixes  |  Parameters  |  Group-By  |  Summative  |  Links  |  e-mail

Basic Query Structure

The basic query structure is a comma delimted list of fields, an `@` sign, followed by an `and` and/or `or` delimited list of conditions.

Here are a few examples:

to get the date and points scored by the Colts in the 2006 season use the SDQL:
date, points @ team=Colts and season=2006

to get the date, points, field goals made and field goals attempted for Bulls home games in 2002 use the SDQL:
date, points, field goals made, field goals attempted @ team=Bulls and site=home and season=2002

to get the date, team, starter, and the number of innings the starter went for all games in the 2007 MLB post season use the SDQL:
date, team, starter, starter innings pitched @ season=2007 and playoffs=1

Many popular sites such as SportsDataBase.com and KillerSports.com provide default fields. For these site if you provide only a condition (with no `@` sign) then a standard output is generated.

To see the SportsDataBase.com standard output including records, summary statistics, and game listing for NBA teams when they are getting more than 10 points at home use the SDQL:
line > 10 and site = home


TOC  |  Introduction  |  Basics  |  Prefixes  |  Parameters  |  Group-By  |  Summative  |  Links  |  e-mail
e-mail links:   Content@SportsDataBase.com    Support@SportsDataBase.com   
Google Group Discussion Forum