计算机程序设计
Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按（）排序。A、emp_idB、emp_nameC、sexD、wage
题目
Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按（）排序。
- A、emp_id
- B、emp_name
- C、sex
- D、wage
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案
第1题：
第(38)～(40) 题基于学生一课程数据库中的3个基本表：
学生信息表：s(sno，sname，sex，age，dept)主码为sno
课程信息表：c(cno，cname，teacher)主码为cno
学生选课信息表：sc(sno，cno，grade)主码为(sno，cno)
实现“从学生信息表中找出性别为女的学生姓名”的SQL语句是
A．SELECT * FROM s
B．SELECT * FROM s WHERE sex='女'
C．SELECT sname FROM s WHERE sex='女'
D．SELECT * FROM s WHERE grade="
正确答案：C
第2题：
S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE)其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号， CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。
A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN＝'王华')
B．SELECT SN, AGE, SEX FROM S WHERE SN='王华'
C．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN＝'王华')
D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华AGE
正确答案：A
解析：选项B查询的结果是显示出姓名为王华的学生姓名、年龄、和性别。
选项C在嵌套的SELECT语句中缺少必要的短语FROM。
选项D格式不正确。
解析：选项B查询的结果是显示出姓名为王华的学生姓名、年龄、和性别。
选项C在嵌套的SELECT语句中缺少必要的短语FROM。
选项D格式不正确。
第3题：
检索所有比“王华”年龄大的学生的姓名、年龄和性别，正确的SELECT语句是______。
A．SELECT SN,AGE,SEX FROM S SHERE AGE＞(SELECT AGE FROM S WHERE SN='王华')
B．SELECT SN,AGE,SEX FROM S WHERE SN='王华'
C．SELECT SN,ACE,SEX FROM S WHERE AGE＞(SELECT ACE WHERE SN='王华')
D．SELECT SN,ACE,SEX FROM S WHERE ACE＞王华 AGE
正确答案：A
解析：本题考查的是书写SQL语句的能力。因为学生关系是S(S#,SN,SEX,AGE)，课程关系是C(C#,CNAME,TEACHER)，学生选课关系是SC(S#,C#,GRADE)，学生关系与课程关系通过学生选课关系连接起来，要检索比“王华”年龄大的学生的姓名、年龄和性别，需要用的数据表为 S，因此选项A的语句
SELECT SN,AGE,SEX FROM S
SHERE AGE＞(SELECTAGE FROM S
WHERE SN='王华')。
满足题目的含义，因此选项A应该是正确答
解析：本题考查的是书写SQL语句的能力。因为学生关系是S(S#,SN,SEX,AGE)，课程关系是C(C#,CNAME,TEACHER)，学生选课关系是SC(S#,C#,GRADE)，学生关系与课程关系通过学生选课关系连接起来，要检索比“王华”年龄大的学生的姓名、年龄和性别，需要用的数据表为 S，因此选项A的语句
SELECT SN,AGE,SEX FROM S
SHERE AGE＞(SELECTAGE FROM S
WHERE SN='王华')。
满足题目的含义，因此选项A应该是正确答
第4题：
S(S,SN,SEX,AGE,DEPT)C(C,CN)SC(S,C,GRADE)其中:S为学号,SN为姓名,SEX为性别,AGE为年龄,DEP
S(S#,SN,SEX,AGE,DEPT) C(C#,CＮ) SC(S#,C#,GRADＥ) 其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号， CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。 正确的SELECT语句是______。
A．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN＝‘王华’)
B．SELECT SN,AGE,SEX FROM S WHERE SN＝‘王华’
C．SELECT SN,AGE,SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN＝‘王华’)
D．SELECT SN,AGE,SEX FROM S WHERE AGE＞王华 AGE
正确答案：A
解析：选项B查询的结果是显示出姓名为王华的学生姓名、年龄、和性别。选项C在嵌套的SELECT语句中缺少必要的短语FROM。选项D格式不正确。
解析：选项B查询的结果是显示出姓名为王华的学生姓名、年龄、和性别。选项C在嵌套的SELECT语句中缺少必要的短语FROM。选项D格式不正确。
第5题：
下面关于TITLE元素说法正确的一项是______。A.TITLE元素由一个起始标记和一个结束标记<／TI</div>
<div class="qoption">
<div class="qcontent"><p>下面关于TITLE元素说法正确的一项是______。</p><p>A．TITLE元素由一个起始标记＜TITLE＞和一个结束标记＜/TITLE＞定界。实际标题位于两个标记之间，而且还要用引号把标题括起来</p><p>B．TITLE元素位于＜SELECT＞…＜/SELECT＞之间</p><p>C．除了TITLE元素外，HEAD之间的元素对文档阅读者来说是不可见的，起码是不可直接见到的</p><p>D．TITLE和文档的文件名作用是一样的</p><p></p></div>
</div>
<br/><div class="qanswer">
<div>
正确答案：C<br>
</div>
</div></p>
</div>
</div>
<div class="col-12">
<div>
<p class="font-weight-bold">第6题：</p>
<p>
<div class="qtitle">检索所有比"王华"年龄大的学生姓名、年龄和性别。正确的SELECT语句是()</div>
<div class="qoption">
<div class="qcontent"><p>A、SELECT SN，AGE，SEX FROM S</p><p>SHERE AGE>(SELECT AGE FROM S)</p><p>WHERE SN=’王华’)</p><p>B、SELECT SN，AGE，SEX</p><p>FROM S</p><p>WHERE SN=’王华’</p><p>C、SELECT SN，ACE，SEX FROM S</p><p>WHERE AGE>(SELECT ACE</p><p>WHERE SN=’王华’)</p><p>D、SELECT SN，ACE，SEX FROM S</p><p>WHERE ACE>王华AGE</p><p></p></div>
</div>
<br/><div class="qanswer">
<div>
参考答案：A<br/>
</div>
</div></p>
</div>
</div>
<div class="col-12">
<div>
<p class="font-weight-bold">第7题：</p>
<p>
<div class="qoption">
<div class="qcontent"><p>The best title for this passage would be ______.</p><p>A) The Importance of Being Visible</p><p>B) Role of Women and Minorities in Management</p><p>C) Job Performance and Advancement</p><p>D) Sex and Career Success</p></div>
</div>
<br/><div class="qanswer">
<div>
正确答案：A<br>答案：A<BR>[试题分析] 主旨题。<BR>[详细解答] 意为：“引人注目的重要性”或“表现自己的重要性”。<BR>
</div>
</div></p>
</div>
</div>
<div class="col-12">
<div>
<p class="font-weight-bold">第8题：</p>
<p>
<div class="qoption">
<div class="qcontent"><p>实现“从学生信息表中找出性别为女的学生姓名”的SQL语句是</p><p>A．SELECT*FROMs</p><p>B．SELECT*FROM s WHERE sex＝'女'</p><p>C．SELECT sname FROM s WHERE sex＝'女'</p><p>D．SELECT*FROM s WHERE grade＝"</p></div>
</div>
<br/><div class="qanswer">
<div>
正确答案：C<br>解析：题目要求是选出姓名字段，而不是所有字段，因此选择C)。
</div>
</div></p>
</div>
</div>
<div class="col-12">
<div>
<p class="font-weight-bold">第9题：</p>
<p>
<div class="qoption">
<div class="qcontent"><p>阅读下列XML文档，回答问题1至问题4，将解答填入对应栏内。</p><p>【XML文档】</p><p>＜? Xml version= "1.0" encoding=" GB2312 "?＞</p><p>＜!—以下是文档的主体部分→</p><p>＜college＞</p><p>＜title＞希赛教育＜/title＞</p><p>＜head＞软考培训部＜/Head＞</p><p>＜Stu_Num unit="人"＞2＜/Stu_Num＞</p><p>＜Student＞</p><p>＜Name＞张网管＜/Name＞</p><p>＜Age＞21 ＜/Age＞</p><p>＜Sex＞男＜/Sex＞</p><p>＜Class＞软考2班＜/Class＞</p><p>＜/Student＞</p><p>＜Student＞</p><p>＜Name＞李软设＜/Name＞</p><p>＜Age＞20＜/Age＞</p><p>＜Sex＞女＜/Sex＞</p><p>＜Class＞软考3班＜/Class＞</p><p>＜/Student＞</p><p>＜/College＞</p><p>与HTML相比，XML具有哪些特点?</p><p></p></div>
</div>
<br/><div class="qanswer">
<div>
正确答案：与HTML相比XML主要有以下特点。
(1)XML是元标记语言。
(2)XML描述的是结构和语义。
(3)XML文档的显示使用特有的技术来支持。<br>与HTML相比，XML主要有以下特点。
(1)XML是元标记语言。
(2)XML描述的是结构和语义。
(3)XML文档的显示使用特有的技术来支持。
</div>
</div></p>
</div>
</div>
<div class="col-12">
<div>
<p class="font-weight-bold">第10题：</p>
<p>
<div class="qoption">
<div class="qcontent"><p>现有一个HTML文档，其中有一段文字是“张莫创建于2003年9月”。这段文字最有可能是放在______之间。</p><p>A．＜TITLE＞…＜/TITLE＞</p><p>B．＜ADDRESS＞…＜/ADDRESS＞</p><p>C．＜TEXTAREA＞…＜/TEXTAREA＞</p><p>D．＜SELECT＞…＜/SELECT＞</p><p></p></div>
</div>
<br/><div class="qanswer">
<div>
正确答案：B<br>
</div>
</div></p>
</div>
</div>
</div>
</div>
</div>
<div class="card mt-3">
<div class="card-header w_primary_border_bottom2"><h5 class="p-0 m-0 line-height-normal">更多相关问题</h5></div>
<div class="mt-3">
<ul class="list-group list-group-flush">
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s53646/sir9xl0V.html">多选题数据库中有一张表名称为Student，有列Number，Name，Age，IDCard，Sex。主键为Number。要求查询所有男同学信息，下列哪个SQL语句是正确的？（）ASelect* From Student Where Sex=’男’BSelect* From Student Where Number NotIn（Select Number From Student Where Sex<>=’男’）CSelect* From Student Where NumberIn（Select Numbe rFrom Student Where Sex=’男’）DSelect* From Student Where Sex<>’男’</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s35744/sN6bnXxS.html">查询语句“SELECT name，sex，birthday FROM human”返回（）列。A、1B、2C、3D、4</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s53647/siYE4dKf.html">单选题Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A
17000.00B
17000*****C
****170.00D
**17000.00E
an error statement</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s35736/sNEunoCo.html">数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求查询所有男同学信息，下列哪个SQL语句是正确的？（）A、Select*FromStudentWhereSex=’男’B、Select*FromStudentWhereSex<>’女’C、Select*FromStudentWhereSexLike’男’D、Select*FromStudentWhereSexIn’男’</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s39465/sU4fN7I.html">The way in which people address each other depends on their age, sex, social group and personal relationship. The English system of address forms frequently used includes first name, last name, title+last name, （）, and kin term.A、title+first nameB、title+titleC、title aloneD、first name+last name+title</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s41154/sNwunHoG.html"> Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A、17000.00B、17000*****C、****170.00D、**17000.00E、an error statement</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s41154/sNwUSi3F.html"> Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 HR_MGR 5000 106 Bryan 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）A、SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;B、SELECT e.employee_id "Emp_id", e.emp_name "Employee",C、salary,D、employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s55164/siQzowek.html">单选题Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?（）A
CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);B
CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);C
CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;D
CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s35736/sNd7GUa9.html">现有三个表即学生表S、课程表C和学生选课表SC，它们的结构如下：S（S#，SN，SEX，AGE，DEPT）；C（C#，CN）；SC（S#，C#，GRADE）。其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号，CN为课程名，GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是（）A、SELECT SN，AGE，SEX FROM SWHE RESN＝“王华”B、SELECT SN，AGE，SEX FROM SWHE REAGE＞（SELECTAGEFROMSWHERESN=“王华”）C、SELECT SN，AGE，SEX FROM SWHE REAGE＞（SELECTAGEWHERESN=“王华”）D、SELECT SN，AGE，SEX FROM SWHE REAGE＞王华.AGE</a></p>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="p-2">
<p class="line-height-normal"><a class="text-primary" href="/c/s56152/siqyxzF9.html">单选题What is the best title for the passage?A
The Place of Women in Society.B
He or She.C
Chairman or Chairwoman.D
Language and Sex.</a></p>
</div>
</li>
</ul>
</div>
</div>
</div>
<div class="col-12">
<div class="card mt-3">
<div class="card-header p-3 w_primary_border_bottom2">
<h5 class="p-0 m-0">相关内容</h5>
</div>
<div class="card-body">
<ul class="list-group list-group-flush">
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s56091/" class="text-dark text-decoration-none">土工试验工</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s39531/" class="text-dark text-decoration-none">00161财务报表分析(一)</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s38667/" class="text-dark text-decoration-none">心血管和肾科团队知识竞赛</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s34508/" class="text-dark text-decoration-none">天津住院医师耳鼻咽喉科</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s34742/" class="text-dark text-decoration-none">地面气象测报上岗考试地面气象观测远程培训考试</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s40403/" class="text-dark text-decoration-none">高等教育学概论</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s55525/" class="text-dark text-decoration-none">肿瘤外科主治医师</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s38170/" class="text-dark text-decoration-none">水泥供料工</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s35166/" class="text-dark text-decoration-none">法律知识法治建设知识竞赛</a>
</div>
</li>
<li class="list-group-item list-group-item-action">
<div class="">
<a href="/c/s54348/" class="text-dark text-decoration-none">学前教育</a>
</div>
</li>
</ul>
</div>
</div>
</div>
<div class="modal fade" id="pay_modal" tabindex="-1" role="dialog" aria-labelledby="pay_modal_title" aria-hidden="true">
</div><!--./pay_modal-->
</div>
<script type="application/ld+json">
{
"@context": "https://zhanzhang.baidu.com/contexts/cambrian.jsonld",
"@id": "https://m.sokaoti.com/c/s35736/sMjBcLi.html",
"title":"Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按（）排序。A、emp_idB、emp_nameC、sexD、wage",
"description": "Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按（）排序。A、emp_idB、emp_nameC、sexD、wage",
"pubDate": "2022-09-12 04:14:06",
"isOriginal": "0"
}
</script>
<script>
var im = navigator.userAgent.toLowerCase().match(/(ipod|iphone|android|coolpad|mmp|smartphone|midp|wap|xoom|symbian|j2me|blackberry|wince)/i) != null;
if (!im) {
window.location.href = "https://www.sokaoti.com/c/s35736/sMjBcLi.html";
}
</script>
</div>
<footer class="border-top footer text-muted">
<div class="container text-center">
<p class="mt-3 line-height-small">
<span class="font-weight-bold">热门分类：</span>
<a class="text-muted" href="/c/s8711/">全科主治</a>
<span> </span>
<a class="text-muted" href="/c/s8733/">主管护师</a>
<span> </span>
<a class="text-muted" href="/c/s8766/">中医助理医师</a>
<span> </span>
<a class="text-muted" href="/c/s8769/">中西医执业</a>
<span> </span>
<a class="text-muted" href="/c/s8773/">护士资格考试</a>
<span> </span>
<a class="text-muted" href="/c/s8777/">执业药师</a>
<span> </span>
<a class="text-muted" href="/c/s8869/">执业中药师</a>
<span> </span>
<a class="text-muted" href="/c/s9084/">住院医师</a>
<span> </span>
</p>
<p class="mt-3">
© 2020-2024 搜考题 www.sokaoti.com - <a href="https://beian.miit.gov.cn/" class="text-muted" target="_blank">苏ICP备2022020371号</a>
</p>
</div>
</footer>
<script src="//lf26-cdn-tos.bytecdntp.com/cdn/expire-1-M/jquery/3.6.0/jquery.min.js" type="application/javascript"></script>
<script src="//lf6-cdn-tos.bytecdntp.com/cdn/expire-1-M/bootstrap/5.1.3/js/bootstrap.bundle.min.js" type="application/javascript"></script>
<script src="/js/common.js?v=HdOE3WPIVd45DWewWGp0gv3eJt-s5hqf2xFcdOqLM9k"></script>
<script charset="UTF-8" id="LA_COLLECT" src="//sdk.51.la/js-sdk-pro.min.js"></script>
<script>LA.init({id: "Jhclq4gxN3m621tw",ck: "Jhclq4gxN3m621tw"})</script>
<script>
var _hmt = _hmt || [];
(function() {
var hm = document.createElement("script");
hm.src = "https://hm.baidu.com/hm.js?3e15275ca5adf7338451e6779c97c181";
var s = document.getElementsByTagName("script")[0];
s.parentNode.insertBefore(hm, s);
})();
</script>
</body>
</html>