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 namesSELECT within SELECT Tutorial
SINSQL Error MessagesSQL Zoo
SQL from JavaSQL from webpageSQL in perl on the Web
SUBSTRSUBSTR/deSUBSTRING
SUBSTRING(ansi)SUBSTRING(ansi)/deSUBSTRING/de
SUMSUM/deSUM and COUNT
SUM and COUNT QuizSandboxScottish Parliament
Select a record with the latest dateSelect the oldest personSelecting NULL values.
Self joinSelf join QuizSet a timeout.
ShellieBoyles923SouthwindSouthwind easy
Southwind hardSouthwind mediumSpecify a date
SqlStarting DB2Starting Ingres
Starting MySQLStarting OracleStarting Postgres
Starting SQL ServerStop queriesStored Procedures
String and datesString contains a quote 'String over columns
StringsStrings/deSubquery and JOIN
Subquery and JOIN2SubsetSubstract dates
Subtract datesTANTO CHAR(dates)
TRIMTable doesn't existTest subquery
The JOIN operationThe nobel table can be used to practice more SUM and COUNT functions.To do list
Tutorial QuizzesUNIONUPDATE
UPDATE existing recordsUnionUsers
Users ReferenceUsing GROUP BY and HAVING.Using Null
Using Null QuizUsing SUM, Count, MAX, DISTINCT and ORDER BYUsing a self join
Using nested SELECTValues and SubtotalsWHERE filters
What 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/deYYYYMMDD date format
Personal tools
Namespaces

Variants
Views
Actions
Reference
Toolbox
Google AdSense