Mysql calcular idade

SELECT * 
FROM alunos a 
INNER JOIN matriculas m ON m.numero_matricula = a.numero_matricula 
WHERE YEAR(FROM_DAYS(TO_DAYS(m.data_matricula) - TO_DAYS(a.alunascimento))) < 17

Mysql calcular idade

SELECT
    YEAR(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(nascimento))) AS idade
FROM
    clientes

Source: pt.stackoverflow.com

Similar codes

0 vote124 views1 answer
Mysql sql.gz
SQL
1 vote121 views1 answer
Mysql remove last empty newline
SQL
2 votes130 views2 answers
Mysql show table column comments sql
SQL
0 vote124 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote120 views1 answer
Set column in all row mysql
SQL
0 vote143 views1 answer
SQL joins in python
SQL
0 vote154 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote110 views1 answer
Truncate table sql server foreign key
SQL
0 vote120 views1 answer
C# datetime to sql server datetime
SQL
0 vote128 views1 answer
Show table details postgresql
SQL