Andmebaaside neljas kodutöö
SELECT 1, 1, 1
UNION ALL
SELECT rowNum+1, fibNum, prevNum + fibNum
FROM fibTable
WHERE rowNum < @fibLen
)
SELECT fibNum
FROM FibTable;
GO
Graaf-tabelid:
SELECT DISTINCT Person.Name, Post.Content
FROM Person, Posted, Post, Likes
WHERE MATCH(Person-(Likes)->Post)
SELECT Person1.Name, Post.Content, Comments.Comment, Person2.Name
FROM Person Person1, Post, Posted, Comments, Person Person2
WHERE MATCH(Person1-(Posted)->Post<-(comments)-Person2)
SELECT Person1.Name, Person2.name, Person3.name
FROM Person Person1, Follows, Person Person2, Follows follows2, Person Person3
WHERE MATCH(Person1-(Follows)->Person2-(Follows2)->Person3)
AND Person1.name = 'Mari'
SELECT Person1.Name, Person2.Name, Post.Content
annaabi.ee 
