Skip to content

Instantly share code, notes, and snippets.

View databraineo's full-sized avatar

Holger databraineo

0 followers · 1 following
View GitHub Profile
@databraineo
databraineo / sql1x1-06.sql
Created August 16, 2019 08:14
Code examples for SQL 1x1 blog-article - 06
SELECT
ArtistId,
Name
FROM Artist
WHERE Name LIKE 'A%' AND NOT Name LIKE '_c%';
@databraineo
databraineo / sql1x1-05.sql
Created August 16, 2019 08:13
Code examples for SQL 1x1 blog-article - 05
SELECT
ArtistId,
Name
FROM Artist
WHERE Name LIKE 'A%';
@databraineo
databraineo / sql1x1-04.sql
Created August 16, 2019 06:43
Code examples for SQL 1x1 blog-article - 04
SELECT
ArtistId,
Name
FROM Artist
WHERE substr(Name,1,1)='A';
@databraineo
databraineo / sql1x1-02.sql
Last active August 16, 2019 06:42
Code examples for SQL 1x1 blog-article - 02
SELECT
ArtistId,
Name
FROM Artist;
@databraineo
databraineo / sql1x1-03.sql
Created August 16, 2019 06:41
Code examples for SQL 1x1 blog-article - 03
SELECT
ArtistId,
Name AS Kuenstler
FROM Artist;
@databraineo
databraineo / sql1x1-01.sql
Created August 16, 2019 06:22
Code examples for SQL 1x1 blog-article - 01
SELECT * FROM Artist;