doubt with age

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Fri, 18 Apr 2008 10:29 am

select p. nascimento, p. person, case when age (p. BIRTH, Sysdate) > = 60 then ' 60 to 69 ' end age from person p, user u where nrregistro = p. u. nrregistro_usuario and u. dtexclusao is null, I'm not getting personal I wanna do a select that bring all people aged greater than 60 how can I do this select?





:?
carlos12
Location: rio

Poston Fri, 18 Apr 2008 10:40 am

guys just getting here! for those who have doubts as I just add AGE (DTNASCIMENTO, Sysdate) > = ' 60 ' valeu personal a strong hug!
carlos12
Location: rio



Return to SQL

Who is online

Users browsing this forum: No registered users and 4 guests