数据库 (database)
文章平均质量分 58
beiyetengqing
http://blog.csdn.net/beiyeqingteng 的镜像站
展开
-
Difference between the having clause and the group by statement
In SQL, the having clause and the group by statement work together when using aggregate functions like SUM, AVG, MAX, etc. This is best illustrated by an example. Suppose we have a table called emp_bo转载 2012-12-23 09:58:27 · 650 阅读 · 0 评论 -
Difference between HAVING and WHERE Clause
Answer in one line is : HAVING specifies a search condition for a group or an aggregate function used in SELECT statement.HAVING can be used only with the SELECT statement. HAVING is typically use转载 2012-12-25 04:21:46 · 923 阅读 · 0 评论 -
How to find duplicate rows with SQL
How to find duplicate rows with SQLThis article shows how to find duplicated rows in a database table. This is a very common beginner question. The basic technique is straightforward. I’ll also转载 2013-10-08 01:10:05 · 1301 阅读 · 0 评论 -
insert into table from another table without duplicate
Table src:CREATE TABLE `src` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL)Table dest:CREATE TABLE `dest` ( `a` int(11) NOT NULL, `b` int(11) DEFAUL原创 2013-10-08 02:18:52 · 787 阅读 · 0 评论 -
双层 not exist 嵌套
关系模式:学生(学号,姓名,系别,年龄)课程(课程号,课程名,学时)选读(学号,课程号,成绩)问题:检索选读全部课程的学生姓名select 学生.姓名 from 学生where not exists(select * from 课程 where not exists(select * from 选读 where 学号=学生.学号 and 课程号=课程.课程号)转载 2013-04-06 03:27:30 · 3369 阅读 · 0 评论 -
数据表链接
问题:假如有一个表 ACCOUNTACCOUNTID, NAME, TYPEA001, JOHN, TUTORA002, MIKE, TUTORA003, JIM, STUDENTA004, LILY, STUDENT另一个表 APPOINTMENTSTUDENTID, TUTORIDA003, A001A004, A002备注:STUD原创 2014-01-19 15:09:38 · 860 阅读 · 0 评论