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

1 vote294 views1 answer
Sql delete all values in a column
SQL
0 vote322 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote317 views1 answer
How to start my sql server on mac
SQL
23 votes331 views4 answers
How to show all users in mysql
SQL
10 votes277 views1 answer
Oracle dependency
SQL
0 vote331 views1 answer
Mysql add to number
SQL
2 votes309 views1 answer
Oracle percentage
SQL
1 vote319 views1 answer
Replace all numbers in mysql
SQL
0 vote332 views2 answers
Get item by composite primary key mysql
SQL
0 vote320 views1 answer
Postgresql check total storage
SQL