网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
问答题
DESC student的作用是什么？
参考答案
参考解析
解析：
暂无解析
更多 “问答题DESC student的作用是什么？” 相关考题
考题
要求选出学生中平均成绩最高的人的学号，姓名和平均分，下列语句中正确的是_____A SELECT TOP 1 学号，姓名，平均分 FROM STUDENT,SKB.DBF ORDER BY 平均分B SELECT TOP 1 STUDENT.学号，STUDENT.姓名，AVG(SKB.成绩) AS 平均分FROM STUDENT INNER JOIN SKB.DBF WHERE STUDENT. 学号=SKB.学号 GROUP BY STUDENT.学号 ORDER BY 3 DESCC SELECT TOP 1 STUDENT.学号，STUDENT.姓名，AVG(SKB.成绩) AS 平均分FROM STUDENT INNER JOIN SKB.DBF ON STUDENT.学号=SKB.学号 GROUP BY STUDENT.学号 ORDER BY 3 DESCD SELECT TOP 1 PERCENT STUDENT.学号，STUDENT.姓名，AVG(SKB.成绩) AS 平均分 FROM STUDENT INNER JOIN SKB.DBF ON STUDENT.学号=SKB.学号 GROUP BY STUDENT.学号 ORDER BY 3 DESC
考题
The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
考题
The STUDENT_GRADES table has these columns:The register has requested a report listing the students‘ grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）A. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;B. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end ASC, gpa ASC;C. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC;D. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC;E. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC;
考题
声明语句＜!ATTIBLIST student studentID ID #REQUIRED＞的作用是（）A、声明元素student的属性studentID是可有可无的B、声明元素student的属性studentID是唯一标识类型，可以省略C、声明元素student的属性studentID是默认取值，可以省略D、声明元素student的属性studentID是唯一标识类型，不可省略
考题
HQL语句：String hql ="from Dept as model order by model.deptName，model.createDate desc"；所表达的意思为（）。A、查询部门，按照deptName的desc排序B、查询部门，按照createDate的desc排序C、查询部门，先按照deptName的desc排序，再按照createDate的desc排序D、查询部门，deptName和createDate的desc排序没有先后之分
考题
下列查询年龄最大的前四个学生（包括并列的情况）的语句，正确的是（）。A、SELECT TOP 4 WITH TIES * FROM Student ORDER BY Sage ASCB、SELECT TOP 4 WITH TIES * FROM Student GROUP BY Sage ASCC、SELECT TOP 4 WITH TIES * FROM Student ORDER BY Sage DESCD、SELECT TOP 4 WITH TIES * FROM Student GROUP BY Sage DESC
考题
现有学生住处表Student_info，其中包括姓名（stu_name），学号（stu_id），成绩（stu_grade）。我们需要查询成绩为80分的学生姓名，要求结果按照学号降序排列。下面查询语句正确的是（）。A、SELECT stu_name FROM student_info Where stu_grade=80 ORDER BY stu_id ASC;B、SELECT stu_name FROM student_info WHERE stu_grade=80 ORDER BY stu_id DESC;C、SELECT stu_id,stu_name FROM student_info WHERE stu_grade=80 ORDER BY stu_name ASC;D、SELECT stu_name FROM student_info WHERE stu_grade LIKE 80 ORDER BY stu_id DESC;
考题
对于如下代码，描述正确的是哪项？（） class Student{ public static void main（String[] args）{ Student student=new Student（）； } } A、new Student（）创建了Student对象的一个实例B、Student student声明了对象Student的一个引用C、class Student声明了一个类D、new Student（）创建了一个类E、Student student 声明了一个类
考题
对于如下代码，描述正确的是哪项？ （） class Student{ public static void main（String[] args）{ Student student = new Student（）； } } A、Student student 声明了一个类B、new Student（）创建了Student 对象的一个实例C、Student student 声明了对象Student 的一个引用D、class Student 声明了一个类
考题
Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task?（）A、SELECT student_ id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC;B、SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks;C、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC);D、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks DESC) WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id ='INT _ SQL';
考题
Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task? （）A、SELECT student_ id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;B、SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;C、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;D、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM = 10;E、SELECT student id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM = 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';
考题
Which statement explicitly names a constraint?（）A、ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students(student_id);B、ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);C、ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);D、ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);E、ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
考题
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）A、SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D、SELECT student_id, gpa FROM student_grades ORDER BY gpa;E、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F、SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
考题
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）A、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;B、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;C、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;D、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;E、SELECT student_id, semester_end, gpa FROM student_grades
考题
多选题对于如下代码，描述正确的是哪项？（） class Student{ public static void main（String[] args）{ Student student=new Student（）； } }Anew Student（）创建了Student对象的一个实例BStudent student声明了对象Student的一个引用Cclass Student声明了一个类Dnew Student（）创建了一个类EStudent student 声明了一个类
考题
多选题对于如下代码，描述正确的是哪项？ （） class Student{ public static void main（String[] args）{ Student student = new Student（）； } }AStudent student 声明了一个类Bnew Student（）创建了Student 对象的一个实例CStudent student 声明了对象Student 的一个引用Dclass Student 声明了一个类
考题
单选题下列查询年龄最大的前四个学生（包括并列的情况）的语句，正确的是（）。A
SELECT TOP 4 WITH TIES * FROM Student ORDER BY Sage ASCB
SELECT TOP 4 WITH TIES * FROM Student GROUP BY Sage ASCC
SELECT TOP 4 WITH TIES * FROM Student ORDER BY Sage DESCD
SELECT TOP 4 WITH TIES * FROM Student GROUP BY Sage DESC
考题
单选题The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）A
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;B
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;C
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;D
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;E
SELECT student_id, semester_end, gpa FROM student_grades
考题
单选题HQL语句：String hql ="from Dept as model order by model.deptName，model.createDate desc"；所表达的意思为（）。A
查询部门，按照deptName的desc排序B
查询部门，按照createDate的desc排序C
查询部门，先按照deptName的desc排序，再按照createDate的desc排序D
查询部门，deptName和createDate的desc排序没有先后之分
考题
单选题Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task? （）A
SELECT student_ id, marks, ROWNUM Rank FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;B
SELECT student_id, marks, ROWID Rank FROM students WHERE ROWID = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;C
SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;D
SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM = 10;E
SELECT student id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM = 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';
考题
在数据库中，删除数据表student的命令是什么？ (1.0分) [单选.]
A. delete table student B. delete student C. drop student D. drop table student
热门标签
最新试卷