2.1.16. Renaming and referencing | Lightenna

2.1.16. Renaming and referencing

AS keyword
(Partial) Attribute renaming in projection list

SELECT fname AS firstName, minit, lname AS surname...

Role names for relations

SELECT S.FNAME, F.FNAME, S.LNAME

FROM STUDENT AS S, STUDENT AS F
WHERE S.LNAME=F.LNAME

(Total) Attribute renaming in FROM

SELECT s.firstName, s.surname

FROM student AS s(firstName,surname,DOB,NINO,tutor)

Wildcards (SELECT s.* FROM...)

s5 slideshow