¹ØÓÚSQLSERVER ²éѯµÄÎÊÌâ
´ó¼ÒºÃ ×î½üÓöµ½µãÂé·³ Çë´ó¼Ò°ïæ ÈçÏ £º
ÎÒÔÚÒ»¸öѧÉúµÄÊý¾Ý¿â STU ÖвéѯSTUDENTS ±íÖÐ Ïà¹ØµÄÊý¾Ý
CREATE TABLE STUDENTS
(
ID INT IDENTITY(1,1) PRIMARY KEY ,
[NAME] VARCHAR(20) NOT NULL,
[CLASS] VARCHAR(10) NOT NULL,
SEX INT NOT NULL, -- 0»ò1
)
±ÈÈç ¸ù¾Ý °à¼¶ ÐÔ±ð ²éѯÐÕÃû
SELECT NAME from STUDENTS WHERE SEX=1 AND CLASS ='01°à'
²éѯ³ö 3000 ÌõÊý¾Ý
·ÖÁ½´ÎÌáÈ¡
ÎÒµÚÒ»´ÎÐèÒª 2000 Ìõ TOP 2000
µÚ¶þ´Î ÎÒÐèҪʣÏ嵀 1000 È»ºó TOP 1000 ....NOT IN... TOP 2000
ÎÒÒÔΪÕâÑù¿ÉÒÔ´ïµ½ÎÒÏ£ÍûµÄ½á¹û µ«ÊÇ
Á½´Î²é³öµÄÊý¾ÝÓкܶàÖØ¸´µÄ
»òÐíÓÐ ÅóÓÑ»á˵ Ä㱿°¡ Ôõô²»¼Ó ORDER BY ID
ÎÒÒ²ÖªµÀ µ«ÊÇ ORDER BY ºó ËÙ¶È»áÏ൱µÄÂý
ËùÒÔÔÚÕâÀï ÇóÖúÀ² ÏÈлл´ó¼ÒÀ²
¿´¿´¼Ó¸öË÷Òý¿ÉÒÔ½â¾ö²»¡£
ûÓÐÅÅÐòÁÐtop»áËæ»ú·µ»ØµÄ¡£
ËٶȲ»»áÏ൱µÄÂý Ö»ÓÐ3000Êý¾Ý
order by ÊDZØÐëµÄ£¬¿ÉÒÔ¿¼ÂÇÔÚidÉϽ¨Ë÷Òý
¿ÉÒÔ¿¼ÂǼӸö¾Û¼¯Ë÷Òý....
SQL code:
SELECT TOP 1000 NAME from (SELECT DISTINCT TOP 2000 NAME from TB)AS T
¼¯ºÏÔËËã·ûEXCEPT¡£ ´Ó×ó²éѯÖзµ»ØÓÒ²éѯûÓÐÕÒµ½µÄËùÓзÇÖØ¸´Öµ¡£
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄѰÉ
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯ ......