SQL复杂练习加JAVA代码实现

复杂sql练习

sql语句

SELECT *,ROUND(DATEDIFF(CURDATE(), birthday)/365.2422) as 'age',
ROUND(DATEDIFF(CURDATE(),entry_date)) as 'entyr_day' from wpx_worker where post like '%理安%' or depart like '%理安%'  

SELECT ROUND(DATEDIFF(CURDATE(), "2001-03-06")/365.2422)


select *,(SELECT case when gender = 1 then '男' ELSE  '女' from wpx_worker) as sex from wpx_worker

select *,gender=(case when gender = 1 then '男' ELSE  '女')   from wpx_worker

select ID, gender=(case gender 
                when 1 then '男' 
                when 2 then '女'
                else ''
                end)           
from wpx_worker




SELECT *,ROUND(DATEDIFF(CURDATE(), birthday)/365.2422) as 'age',
ROUND(DATEDIFF(CURDATE(),entry_date)) as 'entyr_day' from wpx_worker where ROUND(DATEDIFF(CURDATE(), birthday)/365.2422)>15



SELECT 
		TIMESTAMPDIFF(YEAR,a.birthday,CURDATE())AS 'age',a.*,TIMESTAMPDIFF(day,a.entry_date,CURDATE())AS 'day'
		FROM 
		wpx_worker a
		----------------------------------------------------------
		计算的sql
		SELECT SUM(total)as 'leiji',SUM(current)as 'xianyou',SUM(cure)as 'zhiyu',SUM(death)as 'siwang' from district c JOIN data v on c.id = v.continent 

java里面