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 vote229 views1 answer
Sql create and grant user access to database
SQL
0 vote313 views1 answer
Oracle db get table sizes
SQL
0 vote295 views1 answer
Mysql select random rows large table
SQL
0 vote203 views1 answer
Conda install pymysql "windows"
SQL
1 vote169 views1 answer
Unique vs distinct sql
SQL
0 vote211 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
3 votes325 views1 answer
Ssh check mysql version
SQL
0 vote230 views2 answers
What is rownum in oracle
SQL
0 vote186 views1 answer
Ms sql database data size
SQL
0 vote211 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL