数据库
xuantian868
这个作者很懒,什么都没留下…
展开
-
用到的sql
1:SELECT COUNT(DISTINCT IndividualData.recruitFacultyId) AS totalCount FROM IndividualData where (CONVERT(numeric,IndividualData.place)) DISTINCT 为去除重复CONVERT(numeric,IndividualData.place)原创 2007-09-08 11:00:00 · 640 阅读 · 1 评论 -
oracle 相关
1.case用法。SELECT * FROM (SELECT rownum rm,Serial_num,(CASE LOGTYPEWHEN 1 THEN 新增WHEN 2 THEN 修改WHEN 3 THEN 删除WHEN 4 THEN 查询WHEN 5 THEN 登入WHEN 6 THEN 登出WHEN 7 THEN 批次导入WH原创 2008-07-29 11:56:00 · 468 阅读 · 0 评论