Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT nr FROM Aluno;
- SELECT cod,design FROM CADEIRA WHERE CADEIRA.CURSO='AC';
- SELECT Aluno.nome FROM Aluno, Prof WHERE Aluno.nome = Prof.nome;
- /*ou*/
- SELECT nome FROM Aluno INTERSECT SELECT nome FROM Prof;
- SELECT nome FROM Aluno MINUS SELECT nome FROM Prof;
- SELECT nome FROM Aluno UNION SELECT nome FROM Prof;
- SELECT DISTINCT nome FROM Aluno NATURAL JOIN Prova WHERE Prova.cod='TS1' ORDER BY nome;
- SELECT DISTINCT nome FROM Aluno NATURAL JOIN Prova NATURAL JOIN CADEIRA WHERE CADEIRA.CURSO = 'IS' ORDER BY nome;
- SELECT DISTINCT nome FROM Aluno NATURAL JOIN Prova NATURAL JOIN Cadeira WHERE Cadeira.Curso = 'IS' AND Prova.nota >= 10;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement