categories: computer science
Hello everyone,
Below you will find a video with a detailed explanation of the statements and keywords: SELECT, UCASE, LCASE, MID, LEFT, RIGHT, CSTR, CINT, LEN, FROM, WHERE, LIKE, OR, i.e. text functions in general. It covers how they work, their time complexity, and their usefulness. Below you will also find ready-to-copy code in case you need it.
Query 1:
SELECT *
FROM uczniowie
WHERE Imie LIKE '*w'
OR Imie LIKE '?????';
Statements: SELECT, LIKE, FROM, WHERE, OR
Query 2:
SELECT LCASE(LEFT(Imie, 1)) + UCASE(RIGHT(Nazwisko, 1)) AS Inicjaly,
uczniowie.IdUcznia AS Id
FROM uczniowie
WHERE uczniowie.Imie LIKE '?????'
OR uczniowie.Imie LIKE '*w';
Statements: SELECT, LCASE, LEFT, UCASE, RIGHT, AS, LIKE, FROM, WHERE, OR
Query 3:
SELECT MID(Klasa, 2, 1) AS Grupa,
IdUcznia AS Id,
LEN(Imie) AS DlugoscImienia
FROM uczniowie
WHERE Imie LIKE '?????'
OR Imie LIKE '*w';
Statements: SELECT, MID, AS, LEN, FROM, WHERE, LIKE, OR
Query 4:
SELECT CSTR(CINT(MID(Klasa, 1, 1))) AS Kl,
uczniowie.IdUcznia AS Id,
CINT(LEN(Imie)) + CINT(LEN(Nazwisko)) AS DlImieNazwisko
FROM uczniowie
WHERE uczniowie.Imie LIKE '?????'
OR uczniowie.Imie LIKE '*w';
Statements: SELECT, CSTR, CINT, MID, AS, LEN, FROM, WHERE, LIKE, OR
Video:
Thank you for reading!
Read more
