登陆题目详情
单选题 返回组中值的平均值,使用( )函数
学科：数据库原理与应用
时间：2024-01-03 16:07:44
相关题目
相关作业
题目1单选题
返回组中值的平均值,使用( )函数A. minB. avgC. countD. sum
题目2单选题
中华人民共和国于1949年10月1日成立, 使用SQL语句查询当前日期与1949年10月1日相差多少年的方法是A. SELECT DATEDIFF(DAY,'1949-10-1',GETDATE())B. SELECT DATEDIFF(YEAR,'1949-10-1',GETDATE())C. SELECT DATEDIFF(YEAR,GETDATE(),'1949-10-1')D. SELECT DATEDIFF(MONTH,'1949-10-1',GETDATE())
题目3单选题
从教师表中查询年龄大于等于50的女教师的名字 ,或者年龄大于等于60的男教师的名字的方法是A. SELECT Teachername FROM Teacher WHERE (Sex='女' and 2021-YEAR(Brith)>=50) and (Sex='男' and 2021-YEAR(Brith)>=60)B. SELECT Teachername FROM Teacher WHERE (Sex='女' or 2021-YEAR(Brith)>=50) or (Sex='男' or 2021-YEAR(Brith)>=60)C. SELECT Teachername FROM Teacher WHERE (Sex='女' and 2021-YEAR(Brith)>=50) or (Sex='男' and 2021-YEAR(Brith)>=60)D. SELECT Teachername FROM Teacher WHERE (Sex='女' or 2021-YEAR(Brith)>=50) and (Sex='男' or 2021-YEAR(Brith)>=60)
题目4单选题
公民的身份证号采取( )数据类型A. VARCHARB. CHARC. LONGD. INT
题目5单选题
查询既包含'云'又包含'周'的同学的信息的方法是A. SELECT * FROM Student WHERE StudentName like '云%' and StudentName like '周%'B. SELECT * FROM Student WHERE StudentName like '%云%' or StudentName like '%周%'C. SELECT * FROM Student WHERE StudentName like '%云' and StudentName like '%周'D. SELECT * FROM Student WHERE StudentName like '%云%' and StudentName like '%周%'
题目6单选题
从Student表中选取年龄最大的五名男同学的方法是A. SELECT StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄' FROM Student WHERE (Sex = '男') ORDER BY '年龄'B. SELECT TOP (5) StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄' FROM Student WHERE (Sex = '男') ORDER BY '年龄'C. SELECT StudentName AS '姓名', YEAR(Birth) AS '年龄' FROM Student WHERE (Sex = '男') ORDER BY '年龄'D. SELECT TOP (5) StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄' FROM Student WHERE (Sex = '男') ORDER BY '年龄' DESC
题目7单选题
SQL SERVER 中的函数主要有两种,系统函数与( )A. 数学函数B. 用户自定义函数C. 日期函数D. 时间函数
题目8单选题
( )是指表中的一列或多列的组合,该列的值可以唯一的标识表中的记录A. 唯一键B. 关键C. 外键D. 主键
题目9单选题
以下哪种方法能查询出不住在东软宿舍3栋的老师信息A. SELECT * FROM Teacher WHERE HomeAddr != '东软宿舍3栋%'B. SELECT * FROM Teacher WHERE HomeAddr not like '东软宿舍3栋%'C. SELECT * FROM Teacher WHERE HomeAddr like '东软宿舍3栋'D. SELECT * FROM Teacher WHERE HomeAddr like '东软宿舍3栋%'
题目10单选题
数据模型一般应满足三个要求,其中不包括A. 容易被人们理解B. 能够很方便地在计算机上实现C. 比较真实地模拟现实世界D. 模型要简单
下载 题海APP
拍照搜题更快捷
- 海量题库
- 无搜索限制
- 快捷拍照搜题
