hive+sql面试题
金雨陶744数据库SQL查询语句面试题 -
袁奋鲍17154751081 ______ 5.1 select a.username,b.deptname from users a,dept b where a.dept_id=b.id; 5.2 update users set dept_id='9' where dept_id='2'; 5.3 select a.deptname,b.count_id from dept a,(select dept_id,count(id) as count_id from users group by dept_id ...
金雨陶744面试题目(sql) -
袁奋鲍17154751081 ______ 我使用的是MySQL 如下语句:建表语句:create table Lessoninfo( no int,week int,isonduty char); 插入数据:略 insert into Lessoninfo values(...............) SQL查询语句:select no as '教师号', sum(week=1) as '星期一',sum(week=2) as '星期二'...
金雨陶744经典的SQL面试题目,百度有答案,谁有更简洁的 -
袁奋鲍17154751081 ______ select a.id,a.proid as pro1,b.proid as pro2 from (select * from tablename where proid =1) a,(select * from tablename where proid =2) b where a.id=b.id
金雨陶744sql面试题一道 -
袁奋鲍17154751081 ______ --1 查询各部门工资总和SELECT Department 部门名称,sum(CurrentSalary) 工资总和 FROM Office GROUP BY Department--2 查询1982年上半年出生的人SELECT Name 姓名,Birthday 生日 FROM Office WHERE Bi...
金雨陶744面试题目 sql -
袁奋鲍17154751081 ______ select 教师号,sum(CASE 星期号 WHEN 1 THEN 1 ELSE 0 END) AS 星期号1, sum(CASE 星期号 WHEN 2 THEN 1 ELSE 0 END) AS 星期号2, sum(CASE 星期号 WHEN 3 THEN 1 ELSE 0 END) AS 星期号3 FROM 课程表 group by 教师号
金雨陶744有关SQL的面试题... -
袁奋鲍17154751081 ______ 1: 〔车辆〕、〔站台〕、〔行车路线〕最少3个表 〔车辆〕表字段〔ID〕,〔名称〕 〔站台〕表字段〔ID〕,〔名称〕,〔描述〕 〔行车路线〕表字段〔ID〕,〔车ID〕,〔站ID〕 查询: SELECT 〔车辆〕.〔名称〕,〔站台〕.〔名称〕 FROM 〔车辆〕...
金雨陶744一个SQL面试问题,请大家帮帮看如何做: -
袁奋鲍17154751081 ______ select max(PARMENT ) from (select sum(PARMENT) from worker where to_date(PARDAY,'yyyy/mm')=to_date('2003/04','yyyy/mm') group by DEPARTMENT)
金雨陶744一道sql面试题求解 -
袁奋鲍17154751081 ______ 起码还有两种,一种是 delete from a where not exists(select * from b where a.id=b.id) 还有一种是 delete a from a left join b on a.id=b.id where b.id is null
金雨陶744sql题目 写一条sql语句 -
袁奋鲍17154751081 ______ select year1 as year, sum(case when season=1 then que end) season1, sum(case when season=2 then que end) season2, sum(case when season=3 then que end) season3, sum(case when season=4 then que end) season4 from TABLE1 group ...
金雨陶744hive外部表怎么加载分区数据
袁奋鲍17154751081 ______ hivesql sql — 获取指定hive表或指定文件中所有hive表的DDL,如果有按天的分区则默认执行最近7天的分区DDL.同时,table支持符合sql语法的正则表达式,如果有多个表匹配,则提示用户选择(使用file则自动关闭该交互功能).