数据库sql面试题及答案
数据库sql面试题及答案
【篇一：sql数据库经典面试题修改笔试题有答案】部门，平均工资，要求按部门的字符串顺序排序，不能含有huma
resource部门，employee结构如下：employee_idemployee_
amedepart_iddepart_
amewage答selectdepart_
ameavgwagefromemployeewheredepart_
amehuma
resourcegroupbydepart_
ameorderbydepart_
ame
29给定如下sql数据库：test
umi
t4请用一条sql语句返回
um的最小值，但不许使用统计功能，如mi
，max等答
selecttop1
umfromtestorderby
um
33一个数据库中有两个表
一张表为customer，含字段id
ame一张表为order，含字段idcustomerid（连向customer中id的外键）reve
ue；写出求每个customer的reve
ue总和的sql语句。建表createtablecustomeridi
tprimarykey
amechar10gocreatetableorderidi
tprimarykeycustomeridi
tforeig
keyrefere
cescustomeridreve
uefloatgo
16
f查询selectcustomeridsumis
ullorderreve
ue0fromcustomerfulljoi
ordero
ordercustomeridcustomeridgroupbycustomeridselectcustomeridsumorderreve
erfromordercustomerwherecustomeridcustomeridgroupbycustomeridselectcustomeridsumorderreve
erfromcustomerfulljoi
ordero
ordercustomeridcustomeridgroupbycustomerid5数据库（10）atabelcalled“performa
ce”co
tai
：
amea
dscore，please用sql语言表述如何选出score最high的一个（仅有一个）仅选出分数，selectmaxscorefromperforma
ce仅选出名字，即选出名字，又选出分数：selecttop1score
amefromperorderbyscoreselect
ame1scorefromperwherescorei
selectmaxscorefromper4有关系ss
os
amecc
oc
amescs
oc
ograde1问上课程db的学生
oselectcou
tfromcscwherecc
amedba
dcc
oscc
oselectcou
tfromscwherec
oselectc
ofromcwherecc
amedb2成绩最高的学生号selects
ofromscwheregradeselectmaxgradefromsc3每科大于90分的人数selectcc
amecou
tfromcscwherecc
oscc
oa
dscgrade90groupbycc
ameselectcc
amecou
tfromcjoi
sco
cc
oscc
oa
dscgrade90groupbycc
ame数据库笔试题建表：deptdept
oprimarykeyd
amelocemp
26
femp
oprimarykeye
amejobmgrsaldept
o1列出emp表中各部门的部门号，最高工资，最低工资selectmaxsalas最高工资mi
salas最低工资dept
ofromempgroupbydept
o2列出emp表中各部门job为clerk的员工的最低工资，最高工资selectmaxsalas最高工资mi
salas最低工资dept
oas部门号fromempwherejobclerkgroupbydept
o3对于emr