hello im new with sql, i only know this queries to count age but i have task to show all record with conditon age >20select*, year(curdate()) - year(dob) as age from user
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Consider that someone born in 2000 is not 20 yet if their birthday occurred in June or later month. Also, that someone born in May is 20 if their birthday was yesterday, but not if it was on the 29th.
17 People are following this question.
Set an output if and only if two column data match
Want (1) Result with (3) Rows versus what I'm getting now (3) Results with (1) Row
SQL Data retrieval
Is there a way to do a conditional Select?
insert select of millions of records