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
ApostropheAssessment TempAutonumber fields
BBC QUIZBanged porn2073567Beginner tutorial for sql
CASECASE/deCAST
CAST/deCEILCEIL/de
COALESCECOALESCE/deCONCAT
CONCAT/deCOSCOS/de
COUNTCOUNT/deCREATE INDEX
CREATE TABLECREATE TABLE problems: Foreign key references.CREATE TABLE problems: Insufficient privileges.
CREATE TABLE problems: Invalid column name.CREATE TABLE problems: Table already exists.CREATE VIEW
CREATE a VIEWCREATE a foreign keyCREATE a new table
CREATE and DROP ReferenceCURRENT DATECURRENT DATE/de
CURRENT TIMESTAMPCURRENT TIMESTAMP/deChange my own password
Change the default schema/database.Cheat ModeColumn name
Column name with spacesComMySQLCombinations
Combine queriesCombine tablesCommon.css
Components of dateComposite primary keyConcatenate Columns
Concatenate stringsConditional valuesCongestion Charging
Congestion EasyCongestion Easy2Congestion Hard
Congestion Hard2Congestion MediumCongestion Medium2
Create a new userCreate databaseCredit debit
DATEPARTDATEPART/deDATE and TIME Reference
DAYDAY/deDE:Main Page
DELETEDELETE problems: referenceDELETE records
DIVDIV/deDROP
DROP TABLE problems: Foreign key references.DROP a tableData normalization
Date and time typesDate arithmeticsDate functions
Derived tableDressmakerDressmaker easy
Dressmaker hardDressmaker mediumDrucillCanales46
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 spacesFrancoiseDavid321Full text search
Functions ReferenceGenerate rowsGet a date and time right now
Get 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 point
Getting the latest recordHOURHOUR/de
Hacks ReferenceHow can you determine the primary key using SQL?IFNULL
IFNULL/deINSERT: Not all fields need to be specifiedINSERT ... SELECT
INSERT .. SELECTINSERT .. VALUESINSERT a date
INSERT and DELETE OperationsINSERT and DELETE ReferenceINSERT new records
INSERT problems: incompatible formatsINSERT problems: referenceINSTR
INSTR/deINTERVAL of timeImage
Import dataIncorrect GROUP BYInvalid Group function
Issue queriesJOIN Quiz
JOIN Quiz 2LEFTLEFT/de
LEFT JOINLENLEN/de
LENGTHLENGTH/deLanguage Test Page
Language Test Page/deLikeLire notes a propose de cette table.
LissieLangevin333Lower caseMAX
MAX/deMINMIN/de
MINUTEMINUTE/deMOD
MOD/deMONTHMONTH/de
Main PageMain 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 TutorialSELECT from WORLD Tutorial
SELECT within SELECT TutorialSINSQL Error Messages
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