sql面试题及答案

权壮肥3945面试中一道SQL题目!求解
杭玛伏19872524392 ______ select * from 表名 where fenshu >80

权壮肥3945sql查询的一道面试题 -
杭玛伏19872524392 ______ 我觉得应该先将rainDate转换成列,就是列出所有下雨的日期,再选择出未下雨的日期.语句如下:select * from rainDate declare @min int declare @max int declare @Date datetime declare @name...

权壮肥3945SQL面试题 在线等 -
杭玛伏19872524392 ______ select re.sid, max(case se.cname when '物理' then re.score else 0 end) '物理',max(case se.cname when '化学' then re.score else 0 end) '化学',max(case se...

权壮肥3945一道软件测试面试题中的sql题目,求解 -
杭玛伏19872524392 ______ 1. select * from student where score>80 and s_id in (select sid from student_class where c_id=(select c_id from class where c_name='一班')) 2. select c.c_name,女生人数=sum(s.s_id),平均分=avg(s.score) from classes c inner join student_class...

权壮肥3945SQL面试100题
杭玛伏19872524392 ______ http://zhidao.baidu.com/question/123557323.html http://hi.baidu.com/andy_lvhongbo/blog/item/944fd6d964d74d3c32fa1c5e.html

权壮肥3945一道sql面试题,能给出详细的实现语句最好 -
杭玛伏19872524392 ______ SELECT DISTINCT 每个任务所有者当日的总结果数/当日总结果数,每个任务所有者当日的总任务数/当日总任务数,task_owner FROM ( SELECT SUM(result_num) over(PARTITION BY 时间字段截取到日期,result_server) 当日总结果数,...

权壮肥3945软件开发面试中涉及到的SQL方面的经典题目征集 - - 一方有难八方支援!
杭玛伏19872524392 ______ select avg(a.fenshu) from (select top 5 * from chengji order by fenshu desc) a

权壮肥3945有一个SQL数据库的面试题,请会的大侠说下答案,看看有没有什么好的解决方案.
杭玛伏19872524392 ______ select a.id,a.pro1,b.pro2 from (select id,proname as pro1 from q where proid = 1) a inner join (select id,proname as pro2 from q where proid = 2) b on a.id=b.id 其实有很多种方法的

权壮肥3945一道sql面试题
杭玛伏19872524392 ______ 嵌套下就行了挺简单的select sname from s where sno in (select sno from sc where cno = 1 and sno in (select sno from sc where cno = 2));

权壮肥3945麻烦问两个sql查询啊,面试题中遇到的,谢谢! -
杭玛伏19872524392 ______ SELECT SUM(CASE T.TRADE_TYPE WHEN 0 THEN T.AMOUNT ELSE 0 END) - SUM(CASE T.TRADE_TYPE WHEN 1 THEN T.AMOUNT ELSE 0 END) LAST_AMOUNT FROM T_ORDER T WHERE T.CUT_DATE = '20150726';