ÇÚÕÜEXCEL·þÎñÆ÷×óÓÒÄÚÁ¬½Ó¼°ÔÚSQLÓï¾äµÄʵ¼Ê×÷ÓÃ
ÔÚÇÚÕÜEXCEL·þÎñÆ÷ÖÐÓÐ×óÓÒÄÚÁ¬½ÓµÄ²Ù×÷£¬ÎÒÃÇÔÚÕâÀïÓÃSQLÓï¾äÀ´Êµ¼Ê˵Ã÷Ò»ÏÂÖ®¼äµÄÇø±ðÓë×÷Óá£
= ÄÚÁ¬½Ó SQLÖÐΪinner join
*= ×óÁ¬½Ó °üº¬ËùÓеÄ×ó±ß±íÖеļǼÉõÖÁÊÇÓұ߱íÖÐûÓкÍËüÆ¥ÅäµÄ¼Ç¼¡£ SQLÖÐΪleft join
=* ÓÒÁ¬½Ó °üº¬ËùÓеÄÓұ߱íÖеļǼÉõÖÁÊÇ×ó±ß±íÖÐûÓкÍËüÆ¥ÅäµÄ¼Ç¼¡£ SQLÖÐΪright join
ÔÚSQLÓï¾äÖУº
¿ÉÒÔÔÚ from ×Ó¾äÖÐʹÓÃINNER JOINÔËËã¡£.ÕâÊÇ×îÆÕͨµÄÁª½ÓÀàÐÍ¡£Ö»ÒªÔÚÕâÁ½¸ö±íµÄ¹«¹²×Ö¶ÎÖ®ÖÐÓÐÏà·ûÖµ£¬ÄÚ²¿Áª½Ó½«×éºÏÁ½¸ö±íÖеļǼ¡£
Óà LEFT JOIN ÔËËã ´´½¨×ó±ßÍⲿÁª½Ó.×ó±ßÍⲿÁª½Ó½«°üº¬ÁË´ÓµÚÒ»¸ö£¨×ó±ß£©¿ªÊ¼µÄÁ½¸ö±íÖеÄÈ«²¿¼Ç¼£¬¼´Ê¹ÔÚµÚ¶þ¸ö£¨Óұߣ©±íÖв¢Ã»ÓÐÏà·ûÖµµÄ¼Ç¼¡£
ÓÃRIGHT JOIN ÔËËã ´´½¨ ÓÒ±ßÍⲿÁª½Ó.ÓÒ±ßÍⲿÁª½Ó½«°üº¬ÁË´ÓµÚ¶þ¸ö£¨Óұߣ©¿ªÊ¼µÄÁ½¸ö±íÖеÄÈ«²¿¼Ç¼£¬¼´Ê¹ÔÚµÚÒ»¸ö£¨×ó±ß£©±íÖв¢Ã»ÓÐÆ¥ÅäÖµµÄ¼Ç¼¡£
ÀýÈ磬¿ÉÒÔʹÓà LEFT JOIN Ó벿ÃÅ£¨×ó±ß£©¼°Ô±¹¤£¨Óұߣ©±íÀ´Ñ¡ÔñËùÓеIJ¿ÃÅ£¬°üº¬ÁËûÓзÖÅäµ½Ô±¹¤µÄ²¿ÃÅ¡£¿ÉÒÔʹÓà RIGHT JOIN Ñ¡ÔñËùÓеÄÔ±¹¤£¬°üº¬ÁËûÓзÖÅäµ½²¿ÃŵÄÔ±¹¤¡£
ÏÂÁÐʾÀýÏÔʾÈçºÎÔÚÀà±êʶ·û×Ö¶ÎÖÐÁª½ÓÀà±í¼°²úÆ·±í¡£²éѯ½«»áÁгöËùÓÐÖÖÀàµÄÁÐ±í£¬°üº¬ÄÇЩûÓвúÆ·ÔÚÆäÖеÄÖÖÀࣺ
SELECT CategoryName,
ProductName
from Categories LEFT JOIN Products
ON Categories.CategoryID = Products.CategoryID;
Ïà¹ØÎĵµ£º
SQL ServerÊý¾ÝÀàÐÍ2009Äê02ÔÂ02ÈÕ ÐÇÆÚÒ» 11:20Êý¾ÝÀàÐÍÊÇÊý¾ÝµÄÒ»ÖÖÊôÐÔ£¬ÊÇÊý¾ÝËù±íʾÐÅÏ¢µÄÀàÐÍ¡£ÈκÎÒ»ÖÖÓïÑÔ¶¼ÓÐËü×Ô¼ºËù¹ÌÓеÄÊý¾ÝÀàÐÍ£¬SQL ServerÌṩһÏÂ25ÖÖ¹ÌÓеÄÊý¾ÝÀàÐÍ¡£ SQL ServerÊý¾ÝÀàÐÍÒ»ÀÀ±í
¡¡¡¡·Binary [(n)]
·Varbinary [(n)]
·Char [(n)]
·Varchar[(n)]
· ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace ConsoleApplication4
{
class Program
{
static void Main(string[] args)
{
//sqlserverÉí·ÝÑéÖ¤
//string sqlconn = "ser ......
½ñÌìÎÒѧϰÁËsqlµÄ¼òµ¥²éѯÓï¾ä£¬
һЩ»ù±¾µÄ¸ÅÄ
1 ϵͳȨÏÞ£ºÊý¾Ý¿âÖеĶÔÏó£¬ ±í£¬´´½¨±í£¬É¾³ý±í
2 ¶ÔÏóȨÏÞ£º¶ÔÊý¾ÝµÄÔö¡¢É¾¡¢¸Ä¡¢²é¡ ......
´¦ÀíSQL ServerÊý¾Ý¿âÖеĹÂÁ¢Óû§(ͼ)
°ÑÊý¾Ý¿â´ÓÒ»¸ö·þÎñÆ÷ʵÀý¸½¼ÓºÍ»Ö¸´µ½ÁíÒ»¸öʵÀýÖÐÊÇÊý¾Ý¿â¹ÜÀíÔ±Ö´Ðеij£¼ûµÄÈÎÎñ¡£¸½¼Ó»òÕ߻ָ´Ò»¸öÊý¾Ý¿âÖ®ºó£¬Ö®Ç°ÔÚÊý¾Ý¿âÖд´½¨ºÍÅäÖõĵǼÃûÒѾ²»ÄÜ·ÃÎÊÁË¡£Õâ¸öÎÊÌâ×î³£¼ûµÄÖ¢×´ÊÇÓ¦ÓóÌÐò»áÓöµ½µÇ¼ʧ°ÜµÄ´íÎ󣬻òÕßÊǵ±ÄãÊÔ×ŰѵǼÃûÌí¼Óµ½Êý¾Ý¿âÖÐʱ£¬Äã¿ÉÄÜ»áµÃµ½Ò» ......
Sql Server ÓÐÈçϼ¸Ö־ۺϺ¯ÊýSUM¡¢AVG¡¢COUNT¡¢COUNT(*)¡¢MAX ºÍ MIN£¬µ«ÊÇÕâЩº¯Êý¶¼Ö»ÄܾۺÏÊýÖµÀàÐÍ£¬ÎÞ·¨¾ÛºÏ×Ö·û´®¡£Èçϱí:AggregationTable
Id Name
1 ÕÔ
2 Ç®
1 Ëï
1 Àî
2 ÖÜ
Èç¹ûÏëµÃµ½ÏÂͼµÄ¾ÛºÏ½á¹û
Id Name
1 ÕÔËïÀî
2 Ç®ÖÜ
ÀûÓÃSUM¡¢AVG¡¢COUNT¡¢COUNT(*)¡¢MAX ºÍ MINÊÇÎÞ·¨×öµ½µ ......