摘要：SELECT SM_ID,SM_CID,SM_STATION,SM_TIME,PS_CODE,PS_NUMBER,SS_NAME,SS_CODE, (CASE WHEN SM_TYPE=1 THEN '终点站' WHEN SM_TYPE=2 THEN '中转站' END) FROM dbo.PDA_ 阅读全文

摘要： 阅读全文

摘要：此sql语句包括了两个聚合函数做除法求百分比，并保留两位小数，直接输出字符串形式的百分比。以及对case when在聚合函数的应用。SELECT ss.SS_NAME,SS_ID,COUNT(ea.EA_ID) AS EACounts,--回单交换单个数COUNT(eb.EB_ID) AS EBCo... 阅读全文

摘要：第一种 Top剔除法。去除Top （pageIndex-1）*PageSize SELECT TOP 10* FROM dbo.SBD_EXCHANGE_BILL WHERE EB_ID NOT IN (SELECT TOP (10*1) EB_ID FROM dbo.SBD_EXCHANGE_BI 阅读全文