All pages

% MODULO	% MODULO/de	+(dates)
+(dates)/de	+ (string)	+ (string)/de
+ INTERVAL	+ INTERVAL/de	ABS
ABS/de	ALTER	ALTER/de
ALTER TABLE ... ADD COLUMN	ALTER TABLE ... ADD constraint	ALTER TABLE ... DROP COLUMN
AVG	AVG/de	AdventureWorks
AdventureWorks easy questions	AdventureWorks hard questions	AdventureWorks medium questions
AdventureWorks resit questions	Aggregates with DISTINCT	Album
Ambigous column name	Apostrophe	Assessment Temp
Autonumber fields	BBC QUIZ	Banged porn2073567
Beginner tutorial for sql	CASE	CASE/de
CAST	CAST/de	CEIL
CEIL/de	COALESCE	COALESCE/de
CONCAT	CONCAT/de	COS
COS/de	COUNT	COUNT/de
CREATE INDEX	CREATE TABLE	CREATE 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 VIEW	CREATE a foreign key
CREATE a new table	CREATE and DROP Reference	CURRENT DATE
CURRENT DATE/de	CURRENT TIMESTAMP	CURRENT TIMESTAMP/de
Change my own password	Change the default schema/database.	Column name
Column name with spaces	ComMySQL	Combinations
Combine queries	Combine tables	Common.css
Components of date	Composite primary key	Concatenate Columns
Concatenate strings	Conditional values	Congestion Charging
Congestion Easy	Congestion Easy2	Congestion Hard
Congestion Hard2	Congestion Medium	Congestion Medium2
Create a new user	Create database	Credit debit
DATEPART	DATEPART/de	DATE and TIME Reference
DAY	DAY/de	DE:Main Page
DELETE	DELETE problems: reference	DELETE records
DIV	DIV/de	DROP
DROP TABLE problems: Foreign key references.	DROP a table	Data normalization
Date and time types	Date arithmetics	Date functions
Derived table	Dressmaker	Dressmaker easy
Dressmaker hard	Dressmaker medium	DrucillCanales46
EXTRACT	EXTRACT/de	Edinburgh Buses.
Equi Join	Explicitly enter a NULL	Extracting substrings
FLOOR	FLOOR/de	FUNCTIONS
FUNCTIONS/de	Find another process and kill it.	Finding a substring in a string
Forgotten rows	Format a date and time	Format dates
Formating numbers to two decimal spaces	FrancoiseDavid321	Full text search
Functions Reference	Generate rows	Get 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 record	HOUR	HOUR/de
Hacks Reference	How can you determine the primary key using SQL?	IFNULL
IFNULL/de	INSERT: Not all fields need to be specified	INSERT ... SELECT
INSERT .. SELECT	INSERT .. VALUES	INSERT a date
INSERT and DELETE Operations	INSERT and DELETE Reference	INSERT new records
INSERT problems: incompatible formats	INSERT problems: reference	INSTR
INSTR/de	INTERVAL of time	Import data
Incorrect GROUP BY	Invalid Group function	Issue queries
JOIN	JOIN Quiz	JOIN Quiz 2
LEFT	LEFT/de	LEFT JOIN
LEN	LEN/de	LENGTH
LENGTH/de	Language Test Page	Language Test Page/de
Like	Lire notes a propose de cette table.	LissieLangevin333
Lower case	MAX	MAX/de
MIN	MIN/de	MINUTE
MINUTE/de	MOD	MOD/de
MONTH	MONTH/de	Main Page
Main Page/de	Main Page/fr	Manoj
Match a range of dates	Maximum	Meta Data Reference
More JOIN operations	More details about the database.	Multiply sets
Music Tutorial	Musicians	Musicians easy questions
Musicians hard questions	Musicians medium questions	NSS Tutorial
NULL	NULLIF	NULLIF/de
NVL	NVL/de	Neeps
Neeps easy questions	Neeps hard questions	Neeps medium questions
Neeps resit questions	Nested SELECT Quiz	No Group By Function
Nobel Quiz	Old Congestion	Old JOIN Tutorial
Outer joins	PATINDEX	POSITION
Practice for create a table tablename=job	QUARTER	QUARTER/de
QUIZ BBC	RANK	REPLACE
RIGHT	RIGHT/de	ROUND
Range	Read tables from another schema/database	Read the notes about this table.
Read the notes about this table./de	Rename column	Replace a NULL with specific value
Return a sequential record count for all records returned	Rows to columns	Running Total
RuthannIorio236	SECOND	SECOND/de
SELECT	SELECT ... WHERE	SELECT .. GROUP BY
SELECT .. JOIN	SELECT .. SELECT	SELECT .. WHERE
SELECT Quiz	SELECT Reference	SELECT bases
SELECT basics	SELECT basics/de	SELECT from BBC Tutorial
SELECT from MONDE	SELECT from Nobel	SELECT from Nobel Tutorial
SELECT from WORLD Tutorial	SELECT within SELECT Tutorial	SIN
SQL Error Messages	SQL Zoo	SQL from Java
SQL from webpage	SQL in perl on the Web	SUBSTR
SUBSTR/de	SUBSTRING	SUBSTRING(ansi)
SUBSTRING(ansi)/de	SUBSTRING/de	SUM
SUM/de	SUM and COUNT	SUM and COUNT Quiz
Scottish Parliament	Select a record with the latest date	Select the oldest person
Selecting NULL values.	Self join	Self join Quiz
Set a timeout.	ShellieBoyles923	Southwind
Southwind easy	Southwind hard	Southwind medium
Specify a date	Sql	Starting DB2
Starting Ingres	Starting MySQL	Starting Oracle
Starting Postgres	Starting SQL Server	Stop queries
Stored Procedures	String and dates	String contains a quote '
String over columns	Strings	Strings/de
Subquery and JOIN	Subquery and JOIN2	Subset
Substract dates	Subtract dates	TAN
TO CHAR(dates)	TRIM	Table doesn't exist
Test subquery	The JOIN operation	The nobel table can be used to practice more SUM and COUNT functions.
To do list	Tutorial Quizzes	UNION
UPDATE	UPDATE existing records	Union
Users	Users Reference	Using GROUP BY and HAVING.
Using Null	Using Null Quiz	Using SUM, Count, MAX, DISTINCT and ORDER BY
Using a self join	Using nested SELECT	Values and Subtotals
WHERE 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?	YEAR	YEAR/de
YYYYMMDD date format

All pages

Personal tools

Namespaces

Variants

Views

Actions

Search

Reference

Toolbox

Google AdSense