考籍号查询（一）:
询问08年下半年BEC高级广州中山大学考点的考点号是?
如题,因为准考证好像收回去了,我不记得考点号是什么,考点号好像查分的时候需要用到,
我的意思是指填写在准考证上的考点号号码,我是08年下半年已经考完了高级.只是忘记了考点号.
我也是08年11月在中大考的喔~不过我是考中级..考点号是CN145~
考籍号查询（二）:
三．写出以下查询语句： 1. 查询选修了c1这门课的学生的学号，姓名，课程名和成绩。
三．写出以下查询语句：
1. 查询选修了c1这门课的学生的学号，姓名，课程名和成绩。
2. 查询选修了c1这门课的学生的学号，姓名，课程名。
3. 查询“wang”的学号，所选课程号和成绩。
4. 查询所有成绩之和。
5. 查询每一个学生的学号和总成绩。
6. 查询课程平均分在80分以上的课程号和平均分。
7. 查询平均分不低于90分的学生的学号及其平均成绩。
8. 统计每门课程的学生选修人数。要求输出人数超过10人的课程号和选修人数，查询结果按人数降序排列，若人数相同，按课程号升序排列。
我也觉得多，不写了
3、 select sno,cno,gread
from 表
where 条件="wang";
2、 select sno,sname,cname
from 表
where 条件="c1";
1、select sno,sname,cname,gread
from 表
where 条件="c1";
考籍号查询（三）:
EI论文检索号查询求助 A Method Based on Curvelet Transform for Color Image Denoising
Accession number:20114614518039Title:A method based on Curvelet transform for color image denoisingAuthors:Guo, Huina1 ; Cheng, Fengmin2 ; Meng, Mingchuan1 已经检索
考籍号查询（四）:
文章EI检索号查询
文章名：The performance research of different concentrations of methyl adsorption on Si (110) surface
作者：Zhengxin Yan,Dongzhi Yan,Qian Chen,An Gong and Qian Liao
Accession number:20143318064535
Title:The performance research of different concentrations of methyl adsorption onSi (110) surface
Authors:Yan,Zheng Xin1 ;Yan,Dong Zhi1 ;Chen,Qian1;Gong,An1;Liao,Qian1
Author affiliation:1CollegeofScience,Xi"an universityofscience and technology,Xi"an,710054,China
Source title:Advanced MaterialsResearch
Abbreviated source title:Adv.Mater.Res.Volume:988
Monograph title:Material,Mechanical and Manufacturing Engineering II
Issue date:2014
Publication year:2014
Pages:121-124
Language:English
ISSN:10226680
E-ISSN:16628985
ISBN-13:9783038351740
Document type:Conference article (CA)
考籍号查询（五）:
EI会议论文检索号 查询 Effects of GFP Transplastomic Tobacco on Soil Enzyme Activities
Accession number:\x05\x0520114514501868
Title:\x05\x05Effects of GFP transplastomic tobacco on soil enzyme activities
Authors:\x05\x05Guo,Changhong1 ; Liu,Qingguo1 ; Lv,Yueping1
考籍号查询（六）:
EI检索号查询 题目Bionic bladder based depth control for bionic underwater robots 作者wanggang
Accession number:20104213298255
Title:Bionic bladder based depth control for bionic underwater robots
Authors:Wang,Gang1 ; Lin,Longxin1 ; Xu,Haijun1 ; Xie,Haibin1 ; Shen,Lincheng1
Author affiliation:1 National University of Defense Technology,Changsha,China
Corresponding author:Wang,G.(wanggang.seu@gmial.com)
Source title:2010 8th IEEE International Conference on Control and Automation,ICCA 2010
Abbreviated source title:IEEE Int.Conf.Control Autom.,ICCA
Monograph title:2010 8th IEEE International Conference on Control and Automation,ICCA
Issue date:2010
Publication year:2010
Pages:932-936
Article number:5524247
Language:English
ISBN-13:9781424451951
Document type:Conference article (CA)
Conference name:2010 8th IEEE International Conference on Control and Automation
Conference date:June 9,2010 - June 11,2010
Conference location:Xiamen,China
Conference code:81788
Publisher:IEEE Computer Society,445 Hoes Lane - P.O.Box 1331,Piscataway,NJ 08855-1331,United States
Abstract:Depth control of underwater robots is an indispensably function,especially when robots are stationary in water.A bionic bladder system was designed to control the depth of the robots in water.It was composed of a cylinder and a piston.The dynamic models of how the bionic bladder system controls underwater robots were established and based on which a dual-velocity control system was designed.The results of simulation showed that a good control performance could be achieved with proper control parameters.The experiments have been done in water tank to test and validate the performance of the control system.© 2010 IEEE.
Number of references:10
Main heading:Robots
Controlled terms:Bionics - Control system analysis - Control systems - Water tanks
Uncontrolled terms:Control parameters - Control performance - Depth control - System control - Underwater robots
Classification code:446.1 Water Supply Systems - 731 Automatic Control Principles and Applications
DOI:10.1109/ICCA.2010.5524247
Database:Compendex
Compilation and indexing terms,© 2010 Elsevier Inc.
考籍号查询（七）:
数据库实验：统计查询和组合查询
图书（书号,书名,作者编号,价格,出版社编号）
作者（编号,姓名,电话）
出版社（编号,出版社名称,地址）
根据上面基本表的信息完成下列查询.
1 统计各出版社出版图书的数量.
2 列出多人合著的图书书号和价格.
3 列出高教出版社出版的最贵图书信息.
4 列出所有图书都是30元以上的出版社名称.
1 统计各出版社出版图书的数量.
SELECT
出版社.出版社名称,
COUNT(图书.书号) AS 出版图书的数量
FROM
图书,出版社
WHERE
图书.出版社编号 = 出版社.编号
GROUP BY
出版社.出版社名称
2 列出多人合著的图书书号和价格.
SELECT
书号,
价格
FROM
图书
GROUP BY
书号,
价格
HAVING
COUNT(作者编号) >= 2
3 列出高教出版社出版的最贵图书信息.
SELECT
图书.*
FROM
图书,出版社
WHERE
图书.出版社编号 = 出版社.编号
AND 出版社.出版社名称 = "高教出版社"
AND 图书.价格 IN (SELECT MAX(价格) FROM 图书 T WHERE T.出版社编号 = 出版社.编号)
4 列出所有图书都是30元以上的出版社名称.
SELECT
出版社.出版社名称
FROM
图书,出版社
WHERE
图书.出版社编号 = 出版社.编号
GROUP BY
出版社.出版社名称
HAVING
SUM ( CASE WHEN 图书.价格 > 30 THEN 0 ELSE 1 END ) = 0
考籍号查询（八）:
cas号码查询
61607-68-9的cas号
421-50-1的cas号
【CAS号：61607-68-9】
中文：1-(2-二甲基氨基乙基)-1H-5-巯基-四氮唑
英文：1-[2-(Dimethylamino)ethyl]-1H-tetrazole-5-thiol
分子式：C5H11N5S
分子量：173.24
CB号：CB4227359
EC号：262-868-9
【CAS号：421-50-1】
中文：1,1,1-三氟丙酮
英文：1,1,1-Trifluoroacetone
分子式：C3H3F3O
分子量：112.05
CB号：CB4123453
EC号：207-005-9【考籍号查询】
考籍号查询（九）:
由LIN号查到我的V92案件是从2006年3月7号到达广州领事馆.到现在已经快2年了,不知道什么时候能发给我面试通知信.我们全家都很着急,因为和我们一样都是2006年3月7号到达广州领事馆的人已经收到信了,可我们还是没有收到信.希望能早点发给我们通知!
我的A号是:********
由LIN号查到我的V92案件是从2006年3月7号到达广州领事馆.到现在已经快2年了,不知道什么时候能发给我面试通知信.我们全家都很着急,因为和我们一样都是2006年3月7号到达广州领事馆的人已经收到信了,可我们还是没有收到信.希望能早点发给我们通知!谢谢!
我的A号是:********
I found that my V92 case was arrived at GuangZhou consulate 7th,March,2006 based on LIN number.Now two years have passed and I still haven’t get the offer. I was so upset that someone who was arrived at GuangZhou consulate at the same time had already got the offer. Would you please send it to me a.s.a.p, thanks very much.
PS: My A number is:…….
本人笔译的,希望对楼主有所帮助：）
考籍号查询（十）:
EI检索号查询
Analysis on ultimate bearing capacity of the UHV transmission tower with large width angle steel
这是论文题目
Analysis on ultimate bearing capacity of the UHV transmission tower with large width angle steel
Xiao, Qi (School of Architectural and Civil Engineering, Northeast Dianli University, Jilin, 132012, China); Tong, Dan Dan; Song, Ling Feng Source: Applied Mechanics and Materials, v 405-408, p 786-789, 2013, Progress in Industrial and Civil Engineering II
Database: Compendex
Accession number:20134516950737
