All pages

Jump to: navigation, search
All pages
 
All pages
% MODULO% MODULO/de+(dates)
+(dates)/de+ (string)+ (string)/de
+ INTERVAL+ INTERVAL/de258466
ABSABS/deALTER
ALTER/deALTER TABLE ... ADD COLUMNALTER TABLE ... ADD constraint
ALTER TABLE ... DROP COLUMNAVGAVG/de
AdventureWorksAdventureWorks easy questionsAdventureWorks hard questions
AdventureWorks medium questionsAdventureWorks resit questions
Aggregates with DISTINCTAlbumAmbigous column name
ApostropheArchived SELECT from WORLD TutorialAssessment Temp
Autonumber fieldsBBC QUIZBanged porn2073567
Beginner tutorial for sqlCASECASE/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
DrucillCanales46EXTRACTEXTRACT/de
Edinburgh Buses.Equi JoinExplicitly enter a NULL
Extracting substringsFLOORFLOOR/de
FUNCTIONSFUNCTIONS/deFind another process and kill it.
Finding a substring in a stringForgotten rowsFormat a date and time
Format datesFormating numbers to two decimal spacesFrancoiseDavid321
Full text searchFunctions ReferenceGenerate rows
Get 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 recordHOUR
HOUR/deHacks ReferenceHow can you determine the primary key using SQL?
IFNULLIFNULL/deINSERT: Not all fields need to be specified
INSERT ... SELECTINSERT .. SELECTINSERT .. VALUES
INSERT a dateINSERT and DELETE OperationsINSERT 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.LissieLangevin333Lower case
MAXMAX/deMIN
MIN/deMINUTEMINUTE/de
MODMOD/deMONTH
MONTH/deMain PageMain Page/de
Main Page/frManojMatch a range of dates
MaximumMeta Data ReferenceMore JOIN operations
More details about the database.Multiply setsMusic Tutorial
MusiciansMusicians easy questionsMusicians hard questions
Musicians medium questionsNSS TutorialNULL
NULLIFNULLIF/deNVL
NVL/deNeepsNeeps easy questions
Neeps hard questionsNeeps medium questionsNeeps resit questions
Nested SELECT QuizNo Group By FunctionNobel Quiz
Old CongestionOld JOIN TutorialOuter joins
PATINDEXPOSITIONPractice for create a table tablename=job
QUARTERQUARTER/deQUIZ BBC
RANKREPLACERIGHT
RIGHT/deROUNDRange
Read tables from another schema/databaseRead the notes about this table.Read the notes about this table./de
Rename columnReplace a NULL with specific valueReturn a sequential record count for all records returned
Rows to columnsRunning TotalRuthannIorio236
SECONDSECOND/deSELECT
SELECT ... WHERESELECT .. GROUP BYSELECT .. JOIN
SELECT .. SELECTSELECT .. WHERESELECT Quiz
SELECT Quiz1SELECT ReferenceSELECT bases
SELECT basics/deSELECT from BBC Tutorial
SELECT from MONDESELECT from NobelSELECT from Nobel Tutorial
SELECT within SELECT TutorialSIN
SQL Error MessagesSQL ZooSQL from Java
SQL from webpageSQL in perl on the WebSUBSTR
SUBSTR/deSUBSTRINGSUBSTRING(ansi)
SUBSTRING(ansi)/deSUBSTRING/deSUM
SUM/deSUM and COUNTSUM and COUNT Quiz
SandboxScottish ParliamentSelect a record with the latest date
Select the oldest personSelecting NULL values.Self join
Self join QuizSet a timeout.ShellieBoyles923
SouthwindSouthwind easySouthwind hard
Southwind mediumSpecify a dateSql
Starting DB2Starting IngresStarting MySQL
Starting OracleStarting PostgresStarting SQL Server
Stop queriesStored ProceduresString and dates
String contains a quote 'String over columnsStrings
Strings/deSubquery and JOINSubquery and JOIN2
SubsetSubstract datesSubtract dates
TANTO CHAR(dates)TRIM
Table doesn't existTest subqueryThe JOIN operation
The nobel table can be used to practice more SUM and COUNT functions.To do listTutorial Quizzes
UNIONUPDATEUPDATE existing records
UnionUsersUsers Reference
Using GROUP BY and HAVING.Using NullUsing Null Quiz
Using SUM, Count, MAX, DISTINCT and ORDER BYUsing a self joinUsing nested SELECT
Values and SubtotalsWHERE 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?YEAR
YEAR/deYYYYMMDD date format
Personal tools
Namespaces

Variants
Views
Actions
Reference
Toolbox
Google AdSense