Posts by Maycon Guedes • 1 point
2 posts
-
0
votes0
answers39
viewsQ: doubt VIEW Mysql
In a table I have the following columns: nomeAluno, disciplina, numeroDeFaltas. I need a VIEW that I can put the student’s name in the clause WHERE and she returns to me the name of the discipline…
mysqlasked Maycon Guedes 1 -
0
votes4
answers131
viewsQ: MAX with LIMIT does not give the correct result
Imagine the following lines in my Mysql database: I want a query that displays the name and age of the person who has the highest age in the table, for that I did this query: SELECT nome, MAX(idade)…