Posts by Daniela Maia • 185 points
6 posts
-
1
votes1
answer353
viewsQ: Trigger prevents table change
I need to make a Rigger that prevents the same employee from being part of more than one crew on the same day. The crew table is as follows: Tripulação = {id_Voo, data, id_Funcionário } The 3…
-
1
votes1
answer43
viewsQ: Choose second smallest occurrence on a Rigger
Trigger that prevents a candidate who has stayed in the penultimate place during the last two months to apply for a new job so what I need to do is before entering the data into the table…
-
0
votes1
answer321
viewsA: From CTE in SQL to relational algebra
I found two publications in stackoverflow.com that partially answer the question https://stackoverflow.com/questions/28665635/algebra-relational-sql-group-by-sort-by-order-by…
-
1
votes1
answer321
viewsQ: From CTE in SQL to relational algebra
How to pass a CTE in SQL for relational algebra, for example: with publicacao_cte (nome,nr_publicacoes) AS ( select candidato.nome, Count(1) as nr_publicacoes from candidato, cv, ficha_inscricao,…
-
3
votes1
answer62
viewsQ: Select max in nested queries
I have to select the candidate who has more publications than any other candidate. select candidato.nome, Count(1) as nr_publicacoes from candidato, cv,ficha_inscricao, publicacao_cv where…
-
2
votes1
answer36
viewsQ: "order by clauses" can create conflicts between themselves?
It is possible that if we have several clauses in the order by, these conflict with each other? For example: select candidato.nome from candidato, perfil_oferta, prova_de_afericao where candidato.bi…