All pages

Jump to: navigation, search
All pages
 
All pages
% MODULO% MODULO/de+(dates)
+(dates)/de+ (string)+ (string)/de
+ INTERVAL+ INTERVAL/deABS
ABS/deALTERALTER/de
ALTER TABLE ... ADD COLUMNALTER TABLE ... ADD constraintALTER TABLE ... DROP COLUMN
AVGAVG/deAdventureWorks
AdventureWorks easy questionsAdventureWorks hard questionsAdventureWorks medium questions
AdventureWorks resit questionsAggregates with DISTINCT
AlbumAmbigous column nameApostrophe
Archived SELECT from WORLD TutorialAssessment TempAutonumber fields
BBC QUIZCASECASE/de
CASTCAST/deCEIL
CEIL/deCOALESCECOALESCE/de
CONCATCONCAT/deCOS
COS/deCOUNTCOUNT/de
CREATE INDEXCREATE TABLECREATE TABLE problems: Foreign key references.
CREATE TABLE problems: Insufficient privileges.CREATE TABLE problems: Invalid column name.CREATE TABLE problems: Table already exists.
CREATE VIEWCREATE a VIEWCREATE a foreign key
CREATE a new tableCREATE and DROP ReferenceCURRENT DATE
CURRENT DATE/deCURRENT TIMESTAMPCURRENT TIMESTAMP/de
Change my own passwordChange the default schema/database.Cheat Mode
Column nameColumn name with spacesComMySQL
CombinationsCombine queriesCombine tables
Common.cssComponents of dateComposite primary key
Concatenate ColumnsConcatenate stringsConditional values
Congestion ChargingCongestion EasyCongestion Easy2
Congestion HardCongestion Hard2Congestion Medium
Congestion Medium2Create a new userCreate database
Credit debitDATEPARTDATEPART/de
DATE and TIME ReferenceDAYDAY/de
DE:Main PageDELETEDELETE problems: reference
DELETE recordsDIVDIV/de
DROPDROP TABLE problems: Foreign key references.DROP a table
Data normalizationDate and time typesDate arithmetics
Date functionsDerived tableDressmaker
Dressmaker easyDressmaker hardDressmaker medium
EXTRACTEXTRACT/deEdinburgh Buses.
Equi JoinExplicitly enter a NULLExtracting substrings
FLOORFLOOR/deFUNCTIONS
FUNCTIONS/deFind another process and kill it.Finding a substring in a string
Forgotten rowsFormat a date and timeFormat dates
Formating numbers to two decimal spacesFull text searchFunctions Reference
Generate rowsGet a date and time right nowGet the 11th to the 20th rows of the cia table - by population.
Get the first 10 rows of the gisq.cia table.Get to the pointGetting the latest record
HOURHOUR/deHacks Reference
How can you determine the primary key using SQL?IFNULLIFNULL/de
INSERT: Not all fields need to be specifiedINSERT ... SELECTINSERT .. SELECT
INSERT .. VALUESINSERT a dateINSERT and DELETE Reference
INSERT new recordsINSERT problems: incompatible formatsINSERT problems: reference
INSTRINSTR/deINTERVAL of time
ImageImport dataIncorrect GROUP BY
Invalid Group functionIssue queries
JOIN QuizJOIN Quiz 2LEFT
LEFT/deLEFT JOINLEN
LEN/deLENGTHLENGTH/de
Language Test PageLanguage Test Page/deLike
Lire notes a propose de cette table.Lower caseMAX
MAX/deMINMIN/de
MINUTEMINUTE/deMOD
MOD/deMONTHMONTH/de
Main Page/deMain Page/fr
ManojMatch a range of datesMaximum
Meta Data ReferenceMore JOIN operationsMore details about the database.
Multiply setsMusic TutorialMusicians
Musicians easy questionsMusicians hard questionsMusicians medium questions
NSS TutorialNULLNULLIF
NULLIF/deNVLNVL/de
NeepsNeeps easy questionsNeeps hard questions
Neeps medium questionsNeeps resit questionsNested SELECT Quiz
No Group By FunctionNobel QuizOld Congestion
Old JOIN TutorialOuter joinsPATINDEX
POSITIONPractice for create a table tablename=jobQUARTER
QUARTER/deQUIZ BBCRANK
REPLACERIGHTRIGHT/de
ROUNDRangeRead tables from another schema/database
Read the notes about this table.Read the notes about this table./deRename column
Replace a NULL with specific valueReturn a sequential record count for all records returnedRows to columns
Running TotalRuthannIorio236SECOND
SECOND/deSELECTSELECT ... WHERE
SELECT .. GROUP BYSELECT .. JOINSELECT .. SELECT
SELECT .. WHERESELECT QuizSELECT Quiz1
SELECT ReferenceSELECT bases
SELECT basics/deSELECT from BBC TutorialSELECT from MONDE
SELECT from NobelSELECT from Nobel Tutorial
SELECT namesSELECT within SELECT TutorialSIN
SQL Error MessagesSQL Tutorial
SQL ZooSQL from JavaSQL from webpage
SQL in perl on the WebSUBSTRSUBSTR/de
SUBSTRINGSUBSTRING(ansi)SUBSTRING(ansi)/de
SUBSTRING/deSUMSUM/de
SUM and COUNTSUM and COUNT QuizSandbox
Scottish ParliamentSelect a record with the latest dateSelect the oldest person
Selecting NULL values.Self joinSelf join Quiz
Set a timeout.ShellieBoyles923Southwind
Southwind easySouthwind hardSouthwind medium
Specify a dateSqlStarting DB2
Starting IngresStarting MySQLStarting Oracle
Starting PostgresStarting SQL ServerStop queries
Stored ProceduresString and datesString contains a quote '
String over columnsStringsStrings/de
Subquery and JOINSubquery and JOIN2Subset
Substract datesSubtract datesTAN
TO CHAR(dates)TRIMTable doesn't exist
Test subqueryThe JOIN operationThe nobel table can be used to practice more SUM and COUNT functions.
To do listTutorial QuizzesUNION
UPDATEUPDATE existing recordsUnion
UsersUsers ReferenceUsing GROUP BY and HAVING.
Using NullUsing Null QuizUsing SUM, Count, MAX, DISTINCT and ORDER BY
Using a self joinUsing nested SELECTValues and Subtotals
WHERE filtersWhat are my tables?What are the columns of the BBC table?
What are the columns of the cia table?What is the syntax to view structure of table?What version of the software am I using?
Who am I?YEARYEAR/de
YYYYMMDD date format
Personal tools
Namespaces

Variants
Views
Actions
Reference
Toolbox
Google AdSense