记录几条感觉不错的sql语句

来源：互联网发布：java web工作原理编辑：程序博客网时间：2024/04/29 20:23

SELECT id,ip,from_unixtime(last_task_request_time) t1, from_unixtime(last_task_finish_time) t2
FROM yq_nodemanage
WHERE node_type=1
ORDER BY t1 DESC;

SELECT sum(unix_timestamp(gather_time)-unix_timestamp(publish_time))/(count(*)*60) FROM yq_bbs_docinfo

WHERE unix_timestamp(publish_time)>unix_timestamp(now())-12*3600

AND publish_time<gather_time;