sql查询语句中如何调用select的查询结果？ SQL如何在查询结果里再次查询？
sql server\u5982\u4f55\u7528print\u8bed\u53e5\u8f93\u51fa\u67e5\u8be2\u7ed3\u679c1\u3001\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u7a0b\u5e8f\u5c06\u5143\u7ec4\u7684\u591a\u4e2a\u5c5e\u6027\u8f93\u51fa
DECLARE @t1 NVARCHAR(100) --\u58f0\u660e\u4e00\u4e2a\u53d8\u91cf\uff0c\u63a5\u6536\u67e5\u8be2\u7ed3\u679c\u503c\u3002
SELECT @t1=com_name FROM com WHERE cust_id='20100001' --\u67e5\u8be2
PRINT @t1 --\u8f93\u51fa\u7ed3\u679c\u503c\u3002
SELECT @t1=com_name FROM com WHERE cust_id='1405892'
PRINT @t1
SELECT @t1=com_name FROM com WHERE cust_id='569454'
PRINT @t1
SELECT @t1=com_name FROM com WHERE cust_id='647328'
PRINT @t1
SELECT @t1=com_name FROM com WHERE cust_id='1221889'
PRINT @t1
SELECT @t1=com_name FROM com WHERE cust_id='1255607'
PRINT @t1
2\u3001--\u5411\u4e0a\u8fb9\u7684\u6279\u91cfselect\u67e5\u8be2\uff0c\u7528print\u8f93\u51fa\u540e\uff0c\u5728\u6d88\u606f\u4e2d\uff0c\u8fd8\u80fd\u67e5\u770b\u7ed3\u679c\u3002\u5982\u679c\u4e0d\u7528print\uff0c\u5c31\u9700\u8981\u4e00\u4e2a\u4e00\u4e2a\u7684\u590d\u5236\u67e5\u8be2\u7ed3\u679c\u3002
3\u3001--\u4e0a\u8fb9\u7684\u8bed\u53e5\uff0c\u662f\u5728excel\u548cword\u4e2d\u62fc\u63a5\u548c\u66ff\u6362\u503c\uff0c\u5f97\u5230\u7684\u6279\u91cf\u67e5\u8be2\u8bed\u53e5\u3002
\u6269\u5c55\u8d44\u6599\uff1a
1\u3001\u4e0d\u5e26\u8f93\u51fa\u9879\u7684print\u5373\u4e3a\u8f93\u51fa\u4e00\u4e2a\u7a7a\u884c\uff0c\u5982\u679c\u4e4b\u524d\u7684print\u8bed\u53e5\u8f93\u51fa\u9879\u7684\u6700\u540e\u7528\u201c\uff0c\u201d\u6216\u201c\uff1b\u201d\uff0c\u5219\u8868\u793a\u5176\u8f93\u51fa\u662f\u5728\u540c\u4e00\u884c\u4e0a\u3002\u5176\u540e\u9762\u7684\u7a7a\u7684print\u8bed\u53e5\u7528\u6765\u6d88\u9664\u524d\u9762\u7684print\u8bed\u53e5\u4e00\u76f4\u5728\u540c\u4e00\u884c\u4e0a\u8f93\u51fa\u7684\u6548\u679c\uff0c\u4f7f\u5176\u540e\u9762\u7684\u8f93\u51fa\u662f\u5728\u4e0b\u4e00\u884c\u3002
Print()
\u529f\u80fd
\u4ee5\u5f53\u524d\u5b57\u4f53\u5728\u6253\u5f00\u7684\u6253\u5370\u4f5c\u4e1a\u4e2d\u6253\u5370\u4e00\u884c\u6216\u591a\u884c\u6587\u672c\u3002
\u8bed\u6cd5Print(printjobnumber,{tab1,}string{,tab2})
\u4f8b\u5982\u7528\u5728\u7f16\u7a0b\u4e2d\uff1a
\u5b9a\u4e49\u4e00\u4e2a\u6574\u578b\u6570\u7ec4\uff0c\u5c0650\u4e2a\u968f\u673a\u7684\u4e24\u4f4d\u6b63\u6574\u6570\u4ece\u4e0b\u68071\u5f00\u59cb\u653e\u5165\u8be5\u6570\u7ec4\u4e2d\uff0c\u6c42\u51fa\u8be5\u6570\u7ec4\u4e2d\u5177\u6709\u5076\u6570\u503c\u7684\u5076\u6570\u4e0b\u6807\u5143\u7d20\u4e4b\u548c\uff0c\u540c\u65f6\u8f93\u51fa\u8be5\u6570\u7ec4\u4e2d\u6240\u6709\u5143\u7d20\u7684\u503c\uff0c\u6bcf\u884c\u8f93\u51fa10\u4e2a\u503c\u3002
dim a(50) as integer
dim i,s as integer
randomize
s=0
for i=1 to 50
a(i)=int(rnd()*99)+1
if a(i) mod 2=0 then s=s+i
next i
print "s=";s
for i=1 to 50
print a(i);
if i mod 10=0 then print
next i
2\u3001SQL\u4e2dPrint\u8bed\u53e5\u7528\u4e8e\u8c03\u8bd5\uff0c\u6240\u4ee5\uff0c\u5b83\u8f93\u51fa\u7684\u5185\u5bb9\u5c5e\u4e8e\u8c03\u8bd5\u4fe1\u606f\uff0c\u7c7b\u4f3c\u4e8e\u51fa\u9519\u4fe1\u606f\u3002
3\u3001\u5728\u4e0d\u540c\u7684\u7f16\u7a0b\u4e2d\uff0c\u83b7\u53d6\u8c03\u8bd5\u4fe1\u606f\u7684\uff0c\u65b9\u6cd5\u4e0d\u540c\u3002\u6b64\u5916\uff0c\u5f88\u5c11\u6709\u4eba\u7528Print\u4f5c\u6b63\u5e38\u7684\u8f93\u51fa\uff0c\u5f53\u7136\uff0c\u5728\u8c03\u8bd5\u8fc7\u7a0b\u4e2d\u7528\u9664\u5916\u3002\u8981\u8f93\u51fa\u65f6\uff0c\u4e00\u822c\u7528Select\u8bed\u53e5\u6765\u5f97\u65b9\u4fbf\u4e00\u4e9b\u3002\u591a\u7ec4\u4fe1\u606f\u9700\u8981\u8f93\u51fa\u65f6\uff0c\u5148\u751f\u6210\u4e00\u4e2a\u4e34\u65f6\u8868\uff0c\u7136\u540e\u5411\u4e34\u65f6\u8868\u6dfb\u52a0\uff0c\u6700\u540e\u628a\u603b\u7684\u4e34\u65f6\u8868\u6570\u636e\u5411\u524d\u7aef\u63a8\u9001\u5373\u53ef\u3002
\u53c2\u8003\u8d44\u6599\uff1aPrint #_\u767e\u5ea6\u767e\u79d1
\u505a\u6cd5\uff1a\u53ef\u4ee5\u4f7f\u7528\u62ec\u53f7\u201c\uff08select\u67e5\u8be2\u5b50\u53e5\uff09"\u5957\u5d4c\u4e00\u4e2a\u67e5\u8be2\u7ed3\u679c\u3002\u8bed\u6cd5\u683c\u5f0f\uff1aselect columnlist... from (select\u5b50\u53e5) table_name where \u3002\u6ce8\u610f\uff1a\u201d\uff09\u201c \u540e\u9762\u9700\u8981\u7ed9\u67e5\u8be2\u7ed3\u679c\u6307\u5b9a\u4e00\u4e2a\u540d\u79f0 table_name\uff0c\u540d\u79f0\u4e0d\u8981\u4e0e\u5176\u4ed6\u5217\u540d\u79f0\u76f8\u540c\uff0c\u589e\u52a0SQL\u8bed\u53e5\u7684\u53ef\u8bfb\u6027\u3002
\u62d3\u5c55\uff1a
1\u3001SQL\u8bed\u8a00\uff0c\u662f\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00(Structured Query Language)\u7684\u7b80\u79f0\u3002SQL\u8bed\u8a00\u662f\u4e00\u79cd\u6570\u636e\u5e93\u67e5\u8be2\u548c\u7a0b\u5e8f\u8bbe\u8ba1\u8bed\u8a00\uff0c\u7528\u4e8e\u5b58\u53d6\u6570\u636e\u4ee5\u53ca\u67e5\u8be2\u3001\u66f4\u65b0\u548c\u7ba1\u7406\u5173\u7cfb\u6570\u636e\u5e93\u7cfb\u7edf\uff1b\u540c\u65f6\u4e5f\u662f\u6570\u636e\u5e93\u811a\u672c\u6587\u4ef6\u7684\u6269\u5c55\u540d\u3002
2\u3001SQL\u8bed\u8a00\u662f\u9ad8\u7ea7\u7684\u975e\u8fc7\u7a0b\u5316\u7f16\u7a0b\u8bed\u8a00\uff0c\u5141\u8bb8\u7528\u6237\u5728\u9ad8\u5c42\u6570\u636e\u7ed3\u6784\u4e0a\u5de5\u4f5c\u3002\u5b83\u4e0d\u8981\u6c42\u7528\u6237\u6307\u5b9a\u5bf9\u6570\u636e\u7684\u5b58\u653e\u65b9\u6cd5\uff0c\u4e5f\u4e0d\u9700\u8981\u7528\u6237\u4e86\u89e3\u5177\u4f53\u7684\u6570\u636e\u5b58\u653e\u65b9\u5f0f\uff0c\u6240\u4ee5\u5177\u6709\u5b8c\u5168\u4e0d\u540c\u5e95\u5c42\u7ed3\u6784\u7684\u4e0d\u540c\u6570\u636e\u5e93\u7cfb\u7edf\u53ef\u4ee5\u4f7f\u7528\u76f8\u540c\u7684\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\u4f5c\u4e3a\u6570\u636e\u8f93\u5165\u4e0e\u7ba1\u7406\u7684\u63a5\u53e3\u3002SQL\u8bed\u8a00\u8bed\u53e5\u53ef\u4ee5\u5d4c\u5957\uff0c\u8fd9\u4f7f\u4ed6\u5177\u6709\u6781\u5927\u7684\u7075\u6d3b\u6027\u548c\u5f3a\u5927\u7684\u529f\u80fd\u3002
3\u3001\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00SQL\uff08STRUCTURED QUERY LANGUAGE\uff09\u662f\u6700\u91cd\u8981\u7684\u5173\u7cfb\u6570\u636e\u5e93\u64cd\u4f5c\u8bed\u8a00\uff0c\u5e76\u4e14\u5b83\u7684\u5f71\u54cd\u5df2\u7ecf\u8d85\u51fa\u6570\u636e\u5e93\u9886\u57df\uff0c\u5f97\u5230\u5176\u4ed6\u9886\u57df\u7684\u91cd\u89c6\u548c\u91c7\u7528\uff0c\u5982\u4eba\u5de5\u667a\u80fd\u9886\u57df\u7684\u6570\u636e\u68c0\u7d22\uff0c\u7b2c\u56db\u4ee3\u8f6f\u4ef6\u5f00\u53d1\u5de5\u5177\u4e2d\u5d4c\u5165SQL\u7684\u8bed\u8a00\u7b49\u3002
V_COUNT NUMBER;
V_A NUMBER;
V_B NUMBER;
V_C NUMBER;
V_D NUMBER := 092384;
BEGIN
--个数等于3个
SELECT COUNT(1) INTO V_COUNT FROM 理论课程安排 WHERE 教师工号 = V_D;
IF V_COUNT = 3 THEN
SELECT MAX(课程编号) INTO V_A FROM 理论课程安排 WHERE 教师工号 = V_D;
SELECT MAX(课程编号)
INTO V_B
FROM 理论课程安排
WHERE 教师工号 = V_D
AND 课程编号 <> V_A;
SELECT MAX(课程编号)
INTO V_C
FROM 理论课程安排
WHERE 教师工号 = V_D
AND 课程编号 NOT IN (V_A, V_B);
DBMS_OUTPUT.PUT_LINE(V_A);
DBMS_OUTPUT.PUT_LINE(V_B);
DBMS_OUTPUT.PUT_LINE(V_C);
END IF;
END;
返回3个值，3个以内的自己加下判断，3个以上的看多少个值了。
把查询出来的放到表里啊，然后通过表的rows[0][0] 得出第一个课程编号给a 以此类推
什么那是
可以用游标
绛旓細select 鏄煡璇㈠懡浠ゅ憖锛屽彧瑕佹槸鏌ヨ閮借鐢紱select count鏄垎缁勬煡璇紝鐩殑鏄粺璁℃暟閲忥紱select count as 鍜宻elect count鏄竴鏍风殑锛孉S鍚庨潰鏄粰缁熻鏁伴噺鐢熸垚鐨勫垪缁欎釜鍚嶅瓧锛屼笉瑕乤s鐩存帴绌烘牸缁欎釜鍚嶅瓧涔熷彲浠ョ殑銆
绛旓細涓轰簡鍒嗭紝鎴戜篃鏄洰鎷肩殑#鍒涘缓琛ㄥ紑濮媍reate table employee(empid int primary key auto_increment,name varchar(20) not null,sex varchar(5) not null,birth date not null,level varchar(10) not null,salary decimal(12,2) not null);#琛ㄥ垱寤虹粨鏉#鍋囪鏁版嵁宸叉彃鍏#鏌ヨ寮濮 sel1. name 鐜% name...
绛旓細sql="select distinct(selabel)锛&&閫夊彇鏃犻噸澶嶈褰曠殑selabel瀛楁 from kcwl_labprosellog ;&&鏉ヨ嚜琛╧cwl_labprosellog where isdel=0 "&sqlfile&" and selabel not in;&&瀛楁Isdel鍊间负0涓斿瓧娈祍elabel鐨勫间笉瀛樺湪浜庡悗闈㈢殑鏌ヨ涓 (select distinct(selabel) from kcwl_labprosell) "&&閫夊彇kcwl_...
绛旓細1.浣跨敤with瀛愬彞鍙互璁╁瓙鏌ヨ閲嶇敤鐩稿悓鐨剋ith鏌ヨ鍧,閫氳繃select璋冪敤,涓鑸湪with鏌ヨ鐢ㄥ埌澶氭鎯呭喌涓銆2.with瀛愬彞鐨勮繑鍥炵粨鏋滃瓨鍒扮敤鎴风殑涓存椂琛ㄧ┖闂翠腑,鍙仛涓娆℃煡璇,鎻愰珮鏁堢巼銆3.鏈夊涓煡璇㈢殑鏃跺,绗1涓敤with,鍚庨潰鐨勪笉鐢╳ith,骞朵笖鐢ㄩ楀彿闅斿紑銆5.鏈鍚庝竴涓獁ith瀛愬彞涓庝笅闈㈢殑鏌ヨ涔嬮棿涓嶈兘鏈夐楀彿,鍙氳繃鍙虫嫭鍙峰垎鍓,鏌ヨ蹇呴』...
绛旓細select top 43 IDENTITY(int,1,1)AID,name into #t from syscolumns where id=(select id from sysobjects where name='琛ㄥ悕') order by colid declare @AID int,@Sel varchar(1000)select @AID=1,@Sel=''while @AID<=43 begin select @Sel=case when @Sel='' then name else @Sel+'...
绛旓細\x0d\x0a濡傛灉鏄 Oracle 鎴栬 SQL Server 鐨勮瘽銆 鍙互\x0d\x0a\x0d\x0aSELECT\x0d\x0a *\x0d\x0aFROM\x0d\x0a(\x0d\x0a SELECT ROW_NUMBER() OVER( ORDER BY 鎺掑簭鐨勫瓧娈 ) AS 搴忓彿\x0d\x0a 琛.*\x0d\x0a FROM\x0d\x0a 琛╘x0d\x0a) tmp\x0d\x...
绛旓細鎴戠幇鍦ㄩ渶瑕佸皢涓や釜琛閲屾煡璇鐨勭粨鏋滅粨鍚堝埌涓涓暟鎹泦閲岋紵鏄渶瑕佸皢缁撴灉鏀惧湪涓璧凤紝骞朵笖鍒楃殑涓暟涓嶅彉鐨勮瘽灏变娇鐢 union锛堝鏋滃厑璁搁噸澶嶅嚭鐜扮浉鍚岀殑璁板綍灏辨槸鐢 union all锛夛紱濡傛灉鏄渶瑕佸皢缁撴灉鎷兼帴璧锋潵锛堝垪鐨勬暟鐩槸涓や釜琛ㄥ垪鏁颁箣鍜岋級灏变娇鐢╦oin灏嗕袱涓〃鎷兼帴璧锋潵锛宆_^锛屼笉鍚岀殑鎯呭喌涓嶅悓鐨勫鐞嗭紝搴旇鍙互鎼炲畾锛
绛旓細妤间笂閭ｄ釜涓嶈锛屽簲璇ユ槸A娌℃湁鍐嶆壘B 鑰屼笉鏄繛鎺2涓〃涓璧锋壘 妤间富浣犵殑浠ｇ爜鐨勯棶棰樺嚭鍦╳hen id is null 浣犻兘杈撳叆ID=10289浜 id鎬庨杭浼氱┖锛熷簲璇ユ槸 select case when A.name is null then B.name else A.name end name from (select name from a where id = '10289') A,(select name from ...
绛旓細1銆侀鍏堝湪妗岄潰涓婏紝鐐瑰嚮鈥淢anagement Studio鈥濆浘鏍囥2銆佺劧鍚庡湪璇ョ晫闈腑锛岀偣鍑诲乏涓婅宸ュ叿鏍閲鈥滄柊寤鏌ヨ鈥濇寜閽4銆佷箣鍚庡湪璇ョ晫闈腑锛岃緭鍏ユ彁鍙栨棩鏈燂紝骞舵妸骞存湀鏃ュ垎鍒埅鍙栧嚭鏉ョ殑SQL璇彞鈥渟elect year(getdate()),month(getdate()),day(getdate())鈥濄5銆佺劧鍚庡湪璇ョ晫闈腑锛岀偣鍑讳笂鏂瑰乏渚х殑鈥滄墽琛屸濇寜閽6...
绛旓細java涓墽琛sql鎻掑叆璇彞鎬庝箞寮 try { Statement select = DatabaseConnector.getConnection().createStatement( ); String sql="insert into mysql.浼氬憳琛(name,number,sex,email) values ('+username+','+password+','+sex+','+email+')"; sel... 灞曞紑 ...
