Bugl — Daily coding puzzles and drills

Lesson 1visual

ASC Keyword Previous ❮ SQL Keywords Next ASC The ASC command is used to sort the data returned in ascending order. The following SQL statement selects all the columns from the "Customers" table, sort…

2 min

Read lesson →

Lesson 14visual

3 min

Read lesson →

Lesson 21visual

INSERT INTO SELECT Keyword Previous ❮ SQL Keywords Next INSERT INTO SELECT The INSERT INTO SELECT command copies data from one table and inserts it into another table. The following SQL copies "Suppl…

2 min

Read lesson →

Lesson 53visual

2 min

Read lesson →

Lesson 106visual

2 min

Read lesson →

Lesson 207visual

MySQL COALESCE() Function

Example Return the first non-null value in a list: SELECT COALESCE(NULL, NULL, NULL, 'W3Schools.com', NULL, 'Example.com'); Definition and Usage The COALESCE() function returns the first non-null val…

2 min

Read lesson →

Lesson 208visual

MySQL CONNECTION_ID() Function

Example Return the unique connection ID for the current connection: SELECT CONNECTION_ID(); Definition and Usage The CONNECTION_ID() function returns the unique connection ID for the current connecti…

2 min

Read lesson →

Lesson 209visual

MySQL CONV() Function

2 min

Read lesson →

Lesson 210visual

MySQL CONVERT() Function

2 min

Read lesson →

Lesson 211visual

2 min

Read lesson →

Lesson 229visual

SQL Server DATALENGTH() Function

2 min

Read lesson →

Lesson 230visual

2 min

Read lesson →

Lesson 240visual

SQL Server REPLICATE() Function

Example Repeat a string: SELECT REPLICATE('SQL Tutorial', 5); Definition and Usage The REPLICATE() function repeats a string a specified number of times. Syntax REPLICATE( string, integer ) Parameter…

2 min

Read lesson →

Lesson 241visual

SQL Server REVERSE() Function

Example Reverse a string: SELECT REVERSE('SQL Tutorial'); Definition and Usage The REVERSE() function reverses a string and returns the result. Syntax REVERSE( string ) Parameter Values Parameter Des…

2 min

Read lesson →

Lesson 242visual

SQL Server RIGHT() Function

Example Extract 3 characters from a string (starting from right): SELECT RIGHT('SQL Tutorial', 3) AS ExtractString; Definition and Usage The RIGHT() function extracts a number of characters from a st…

2 min

Read lesson →

Lesson 243visual

SQL Server RTRIM() Function

Example Remove trailing spaces from a string: SELECT RTRIM('SQL Tutorial ') AS RightTrimmedString; Definition and Usage The RTRIM() function removes trailing spaces from a string. Note: Also look at…

2 min

Read lesson →

Lesson 244visual

2 min

Read lesson →

Lesson 281visual

Read lesson →

Lesson 295visual

SQL Server COALESCE() Function

Example Return the first non-null value in a list: SELECT COALESCE(NULL, NULL, NULL, 'W3Schools.com', NULL, 'Example.com'); Definition and Usage The COALESCE() function returns the first non-null val…

2 min

Read lesson →

Lesson 296visual

2 min

Read lesson →

Lesson 329visual

SQL Statement Syntax AND / OR SELECT column_name(s) FROM table_name WHERE condition AND|OR condition ALTER TABLE ALTER TABLE table_name ADD column_name datatype or ALTER TABLE table_name DROP COLUMN…

2 min

Read lesson →

SQL References

SQL Data Types for MySQL, SQL Server, and MS Access

SQL Keywords Reference

SQL ADD Keyword

SQL ADD CONSTRAINT Keyword

SQL ALL Keyword

SQL ALTER Keyword

SQL ALTER COLUMN Keyword

SQL ALTER TABLE Keyword

SQL ALTER VIEW Keyword

SQL AND Keyword

SQL ANY Keyword

SQL AS Keyword

SQL ASC Keyword

SQL BACKUP DATABASE Keyword

SQL BETWEEN Keyword

SQL CASE Keyword

SQL CHECK Keyword

SQL COLUMN Keyword

SQL CONSTRAINT Keyword

SQL CREATE Keyword

SQL CREATE DATABASE Keyword

SQL CREATE INDEX Keyword

SQL CREATE OR REPLACE VIEW Keyword

SQL CREATE TABLE Keyword

SQL CREATE PROCEDURE Keyword

SQL CREATE UNIQUE INDEX Keyword

SQL CREATE VIEW Keyword

SQL DATABASE Keyword

SQL DEFAULT Keyword

SQL DELETE Keyword

SQL DESC Keyword

SQL SELECT DISTINCT Keyword

SQL DROP Keyword

SQL DROP COLUMN Keyword

SQL DROP CONSTRAINT Keyword

SQL DROP DATABASE Keyword

SQL DROP DEFAULT Keyword

SQL DROP INDEX Keyword

SQL DROP TABLE and TRUNCATE TABLE Keywords

SQL DROP VIEW Keyword

SQL EXEC Keyword

SQL EXISTS Keyword

SQL FOREIGN KEY Keyword

SQL FROM Keyword

SQL FULL OUTER JOIN Keyword

SQL GROUP BY Keyword

SQL HAVING Keyword

SQL IN Keyword

SQL INDEX Keyword

SQL INNER JOIN Keyword

SQL INSERT INTO Keyword

SQL INSERT INTO SELECT Keyword

SQL IS NULL Keyword

SQL IS NOT NULL Keyword

SQL JOIN Keyword

SQL LEFT JOIN Keyword

SQL LIKE Keyword

SQL SELECT TOP, LIMIT and ROWNUM Keywords

SQL NOT Keyword

SQL NOT NULL Keyword

SQL OR Keyword

SQL ORDER BY Keyword

SQL FULL OUTER JOIN Keyword

SQL PRIMARY KEY Keyword

SQL CREATE PROCEDURE Keyword

SQL RIGHT JOIN Keyword

SQL SELECT TOP, LIMIT and ROWNUM Keywords

SQL SELECT Keyword

SQL SELECT DISTINCT Keyword

SQL SELECT INTO Keyword

SQL SELECT TOP, LIMIT and ROWNUM Keywords

SQL SET Keyword

SQL TABLE Keyword

SQL SELECT TOP, LIMIT and ROWNUM Keywords

SQL DROP TABLE and TRUNCATE TABLE Keywords

SQL UNION Keyword

SQL UNION ALL Keyword

SQL UNIQUE Keyword

SQL UPDATE Keyword