I have a simple command
SELECT MATRICULA FROM ALUNOS WHERE ID_ALUNO IN (1,2,3,4,5,6)
I would like to know how to get a result like this in SQL:
ID | STUDENT
1 | LUIZ
2 | MARIA
3 |
4 | JOHN
5 | CARLOS
6 |
That is, bring the ones he found, and those he did not think left blank ... does he have via SQL?
I'm using Oracle 11