С²¼×÷Æ·£ºOracle 11g SQL»ù´¡ÈëÃÅϵÁÐÅàѵ(È«30½²)
==============================================
µÚ01½²: Chapter 00--Oracle 11g SQL Fundamentals Training Introduction
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2003
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2003.zip
µÚ02½²: Chapter 00--Oracle 11g SQL Fundamentals Training Introduction
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2004
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2004.zip
µÚ03½²: Chapter 01--Restricting Data Using the SQL SELECT Statement
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2005
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2005.zip
µÚ04½²: Chapter 01--Restricting Data Using the SQL SELECT Statement
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2006
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2006.zip
µÚ05½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2008
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2008.zip
µÚ06½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2009
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2009.zip
µÚ07½²: Chapter 02--Restricting and Sorting Data
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2021
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2021.zip
µÚ08½²: Chapter 03--Using Single-Row Functions to Customize Output
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2022
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2022.zip
µÚ09½²: Chapter 03--Using Single-Row Functions to Customize Output
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2023
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2023.zip
µÚ10½²: Chapter 04--Using Conversion Functions and conditional Expressions
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2024
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2024.zip
µÚ11½²: Chapter 04--Using Conversion Functions and conditional Expressions
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk2025
ÊÓÆµÏÂÔØ£º http://www.boobooke.com/v/bbk2025.zip
µÚ12½²: Chapter 05--Reporting Aggregated Data Using the Group Functions
ÔÚÏß¹Û¿
Ïà¹ØÎĵµ£º
Óŵã:×ֶνÏÉÙ£¬ÓÐÔöɾ¸Ä²é¹¦ÄÜ£¬²»¹ý²éѯ̫Áýͳ¡£
ȱµã:
1.²»ËãÊÇÔÚºÜÕýµÄÎÞÏÞ·ÖÀà,ClassPathÕâ¸ö×ֶζ¨ÒåÏÞÖÆ¡£
2.Ö÷¼üCLASSID²»ÊÇ×ÔÔöµÄ£¬Ê¹ÓÃCODESMITHÅúÁ¿Éú³É¶à²ã¼Ü¹¹´úÂëÖлᵼÖ³ö´í¡£
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ArticleClass]') and OBJECTPROPERTY(id, N'IsUse ......
SQLµ±Ç°ÈÕÆÚ»ñÈ¡¼¼ÇÉ
select getdate() //2003-11-07 17:21:08.597
select convert(varchar(10), getdate(),120) //2003-11-07
select convert(char(8),getdate(),112)  ......
Óï¾äÐÎʽ£º¡¡ SELECTTOP10*
fromTestTable
WHERE(ID>
¡¡¡¡¡¡¡¡¡¡(SELECTMAX(id)
¡¡¡¡¡¡¡¡from(SELECTTOP20id
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡fromTestTable
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ORDERBYid)AST))
ORDERBYID
SELECTTOPÒ³´óС*
fromTestTable
WHERE(ID>
¡¡¡¡¡¡¡¡¡¡(SELECTMAX(id)
¡¡¡¡¡¡¡¡from(SELECTTOPÒ³´óС*Ò³Êýid
¡¡¡¡¡ ......
CREATE Table <±íÃû>
£¨[<ÁÐÃû1>] ÀàÐÍ (³¤¶È) [ȱʡֵ][Áм¶Ô¼Êø]
[£¬<ÁÐÃû2> Êý¾ÝÀàÐÍ[ȱʡֵ][Áм¶Ô¼Êø]]….
[£¬UNIQUE£¨ÁÐÃû[£¬ÁÐÃû]….£©]
[£¬PRIMARY KEY£¨ÁÐÃû[£¬ÁÐÃû]…£©]
&n ......