qwer78

摘要： 分组之后取每组之内根据排序字段的第一行值 （可以根据rownum 随便取） SELECT * FROM ( SELECT *, ROW_NUMBER () OVER ( PARTITION BY [分组字段] ORDER BY [排序字段] ) rownum FROM 表名 ) t WHERE ro 阅读全文

摘要： import com.alibaba.fastjson.JSONObject; import fangrong.com.cn.constant.ResultCode; import lombok.extern.slf4j.Slf4j; import org.apache.http.*; import 阅读全文

摘要： 1.配置 #第一数据源 spring.datasource.primary.jdbc-url=jdbc:sqlserver://192.168.1.159\\aaa:1433;database=dataserver spring.datasource.primary.username=sa spri 阅读全文

摘要： 1.docker stats 命令查看服务资源占用情况 获取cpu异常的容器id 60a01eab867b 2.docker exec -it 60a01eab867b /bin/bash 命令进入容器 3.top 命令查看该容器线程占用最高的进程PID 1 4.ps -mp 1 -o THREAD 阅读全文

摘要： SELECT SUM ( CASE WHEN area_name IS NULL THEN 0 ELSE 1 END ) AS '有值', COUNT ( id ) AS "总数" FROM beike_property 阅读全文

摘要： SELECT DISTINCT ( object_id ) FROM ( SELECT TOP 100 PERCENT a.*, b.cnt FROM weChat_share a LEFT JOIN ( SELECT object_id, COUNT ( object_id ) cnt FROM 阅读全文

摘要： import com.alibaba.fastjson.JSONObject; import com.google.common.util.concurrent.RateLimiter; import org.slf4j.Logger; import org.slf4j.LoggerFactory; 阅读全文

摘要： SELECT COUNT ( [size] ) num FROM crawler_publish_property WHERE CAST ( ISNULL( [size], 0 ) AS NUMERIC ( 10, 2 ) ) >= 0 AND CAST ( ISNULL( [size], 0 ) 阅读全文

摘要： SELECT t1.num, t1.estate_name AS ename, t2.* FROM ( SELECT TOP 100 PERCENT COUNT ( estate_name ) num, estate_name FROM crawler_property GROUP BY estat 阅读全文

摘要： public static String jsoupEntity(String url1) { InputStream is = null; BufferedReader buffer = null; try { String[] ips = newIp();//获取自定义ip 127.0.0.1: 阅读全文