![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql学习笔记
文章平均质量分 84
wujilin
这个作者很懒,什么都没留下…
展开
-
third day
对表的一些基本操作1 Creating a TablesyntaxCREATE TABLE Tablename (column_name type, column_name, type, .....)for exampleCREATE TABLE Employee (names VARCHAR(20),原创 2006-09-25 22:20:00 · 649 阅读 · 0 评论 -
fourthly day
JOins Jions a common way to combine table in SQL.1 we use the JOIN keyword and an ON clause.syntax isSELECT columnsFROM table1 JOIN table2ON table1.column1=table2.column1Note th原创 2006-09-26 22:01:00 · 661 阅读 · 0 评论 -
sixth day
1 Noncorrelated SubqueriesA noncorrelated subquery is a subquery that is independent of the outer query. In other words, the subquery could be executed on its own. The following is an example of原创 2006-10-02 18:05:00 · 645 阅读 · 0 评论 -
the first day
今天开始看SQL 打算半个月搞定这本书第一天读书笔记1 SQL Server 2005 comes with some default System databases--master, model, msdb, and tempdbmaster is a database composed of system tables that keeps track of ser原创 2006-09-23 21:24:00 · 833 阅读 · 2 评论 -
second day
Learn how to write (build) simple SQL query statements in SQL Server 2005 using the SELECT statement. 1 Displaying or Selecting Columns from a TableUsing a SELECT statement, we do not have to di原创 2006-09-24 14:25:00 · 904 阅读 · 2 评论 -
fifthly day
About Aggregate Function1An aggregate function basically combines multiple rows into a single number. Aggregate functions can be used to count the number of rows, find the sum or average of all原创 2006-09-28 20:27:00 · 660 阅读 · 0 评论