Blog

use enoz_admin_20240311
go

SELECT TOP(100) 
    (DATEPART(YEAR, GETDATE()) - LEFT(m_birthday, 4) + 1) AS age, * 
FROM 
    member_tbl 
WHERE 
    ((DATEPART(YEAR, GETDATE()) - LEFT(m_birthday, 4) + 1) >= 17) 
ORDER BY 
    idx DESC