代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/438748/7727534
sql 54002.sql
www.eeworm.com/read/438748/7727535
sql 54003.sql
-- -------------------------------------------------
-- Filename: 54003.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 03
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/438748/7727536
sql 54005.sql
-- -------------------------------------------------
-- Filename: 54005.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 05
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/438748/7727537
sql 54006.sql
-- -------------------------------------------------
-- Filename: 54006.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 06
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/438713/7727927
sql murachdbcreate.sql
CONNECT 'jdbc:derby:MurachDB;create=true';
CREATE TABLE Products
(
ProductCode VARCHAR(10),
Description VARCHAR(50),
Price DOUBLE
);
INSERT INTO Products
VALUES ('bvbn', '
www.eeworm.com/read/438626/7729083
sql order by.sql
SELECT STU_NAME AS '学生名',STU_SCORE AS '成绩'
FROM STUDENT
ORDER BY STU_SCORE DESC/*按成绩降序进行排序*/
--------------------------------------
SELECT STU_NAME AS '学生名',STU_SCORE AS '成绩'
FROM STUDENT
ORDER
www.eeworm.com/read/438626/7729084
sql 外连接.sql
SELECT STU_NAME AS '学生姓名',CLASS_NAME AS'班级'
FROM STUDENT RIGHT OUTER JOIN CLASS ON STUDENT.CLASS_ID=CLASS.CLASS_ID
/*外连接,注意没有班级的学生在结果表仍将显示*/
www.eeworm.com/read/438626/7729087
sql compute by.sql
SELECT CLASS_NAME,STU_SCORE
FROM STUDENT INNER JOIN CLASS ON STUDENT.CLASS_ID=CLASS.CLASS_ID
WHERE STUDENT.CLASS_ID=CLASS.CLASS_ID
ORDER BY STUDENT.CLASS_ID
COMPUTE AVG(STU_SCORE) BY STUDENT.CLASS
www.eeworm.com/read/438626/7729090
sql group by运用.sql
SELECT AVG(STU_SCORE) AS '班级成绩',CLASS_NAME AS '班级名'
FROM STUDENT INNER JOIN CLASS ON STUDENT.CLASS_ID=CLASS.CLASS_ID
GROUP BY CLASS_NAME/*查询个班级的平均成绩*/
www.eeworm.com/read/438626/7729092
sql cube.sql
SELECT ISNULL(TEA_NAME,'班级成绩汇总'),ISNULL(CLASS_NAME,'汇总计算') ,avg(STU_SCORE)
FROM STUDENT INNER JOIN CLASS ON STUDENT.CLASS_ID=CLASS.CLASS_ID
INNER JOIN TEA_STU ON STUDENT.STU_ID=TEA_STU.STU_ID INNER