[sql笔试题写出这个sql]此题的考点是行转列，可用case when +group by 实现 具体如下 select s.userid, max(case when s.typeid=1 then s.vaule END) 手机号码， max(case when s.typeid=2 then s.vau...+阅读
帮忙！我SQL学的不好金蝶的SQL面试题谁给我讲解下
问题1答案： select a.人员资料 from A表 as a, B表 as b, C表 as c where a.借书证号 = b.借书证号 and b.借阅编号 = c.借阅编号 and count(c.图书编号) >5 问题2答案： create proc proc_book bookID varchar(20), bookInfo varchar(20), borrID varchar(20) as if (bookIDst112) begin insert into C表 values(bookID,bookInfo,borrID) return 1 end else return 0 go exec proc proc_book st111 书名 AS111 问题3答案： select a.人员资料 from A表 as a, B表 as b, C表 as c where a.借书证号 = b.借书证号 and b.借阅编号 = c.借阅编号 添加约束： alter table 表名 add constraint 约束名 约束类型 具体的约束说明 创建视图： create view 视图名 as select语句
求sql语句怎么写金蝶面试题 MySQL大家论坛
第一个select sum(FSAL) as salary from table1 where year(FDATE)=year(now()) and FNAME=\'张三\'；第二个select sum(FSAL),sum(FSAL)/52/count(DISTINCT FID),sum(FSAL)/12/count(DISTINCT FID),sum(FSAL)/count(DISTINCT FID)from table1 where year(FDATE)=year(now（)）；第三个select FID,FNAME from table1 where sum(FSAL)/12 between 600 and 800;
延伸阅读：
出个Sql面试题！--总体情况 SELECT a.ID, COUNT(*) AS 总数， SUM(CASE b.STYLE WHEN 0 THEN 1 ELSE 0 END ) AS 过关数， SUM(CASE b.STYLE WHEN 1 THEN 1 ELSE 0 END ) AS 未过关数 from a, b...
SQL面试题。帮忙解答。谢谢(1): select 姓名，科目，成绩 from t表 a where not exists(select * from t表 b where b.成绩 （2）: delete from t表 where id not in( select id from t表 a where id in(selec...
SQL语句面试题恩，通过自定义函数吧。。 实现如下： ----创建自定义函数 create function F_Getvarchar(a1 int) returns varchar(8000) as Begin declare a2 varchar(100),Newvarhar varchar...
有关SQL的面试题。。1: 〔车辆〕、〔站台〕、〔行车路线〕最少3个表 〔车辆〕表字段〔ID〕，〔名称〕 〔站台〕表字段〔ID〕，〔名称〕，〔描述〕 〔行车路线〕表字段〔ID〕，〔车ID〕，〔站ID〕 查询： SEL...
面试题目sql我使用的是MySQL 如下语句： 建表语句： create table Lessoninfo( no int, week int, isonduty char); 插入数据：略 insert into Lessoninfo values(...............) SQL查询语...
求sql语句怎么写金蝶面试题 MySQL大家论坛第一个select sum(FSAL) as salary from table1 where year(FDATE)=year(now()) and FNAME=\'张三\'；第二个select sum(FSAL),sum(FSAL)/52/count(DISTINCT FID),sum(FSAL)/1...
急求Sql Server数据库SQL语句面试题What are two methods of retrieving SQL? What cursor type do you use to retrieve multiple recordsets? What is the difference between a “where” clause and a “h...
帮忙我SQL学的不好金蝶的SQL面试题谁给我讲解下问题1答案： select a.人员资料 from A表 as a, B表 as b, C表 as c where a.借书证号 = b.借书证号 and b.借阅编号 = c.借阅编号 and count(c.图书编号) >5 问题2答案： creat...
sql语句面试题1.SELECT s.SNO,SNAME FROM S s,SC sc WHERE s.SNO=sc.SNO AND sc.CNO IN(SELECT CNO FROM C WHERE TNO= (SELECT TNO FROM T WHERE)); 2.SELECT SNO FROM SC WHERE CNO IN(...
