qq_35392981的博客

c3p0-config.xml配置<?xml version="1.0" encoding="UTF-8" ?><c3p0-config> <default-config> <property name="jdbcUrl">jdbc:sqlserver://localhost:1433;databaseName=fn</property> <property name="driverClass"

一、分组查询获取最新SELECT * FROM exams A WHERE 1>(SELECT COUNT(1) FROM exams WHERE A.exam_date<exam_date AND A.health_record_code=health_record_code AND A.org_code=org_code AND status = 1)AND A.status = 1二、分组排序查询获取最新SELECT * FROM(SELECT *, row_nu