sql Áгö
sqlÓï¾ä²éѯij×ֶεÄÊý¾Ý×ܺÍ,²¢Áгö±íÖеÄËùÓмǼ¡£ - °Ù¶È...
1¡¢Ê×ÏÈ£¬´´½¨Ò»¸ö²âÊÔ±í£¬Ïà¹Ø´úÂëÈçÏ£¬½øÈëÏÂÒ»²½¡£2¡¢Æä´Î£¬Ö´ÐÐÍêÉÏÃæµÄ²Ù×÷Ö®ºó£¬²åÈë²âÊÔÊý¾Ý£¬Ïà¹Ø´úÂë...
ÇëÁгöSQL servelÊý¾Ý¿âÖг£¼ûµÄÊý¾Ý¿â¶ÔÏó¡£
8 ´æ´¢¹ý³Ì£¨Stored Procedure£©´æ´¢¹ý³ÌÊÇΪÍê³ÉÌض¨µÄ¹¦Äܶø»ã¼¯ÔÚÒ»ÆðµÄÒ»×éSQL ³ÌÐòÓï¾ä£¬¾±àÒëºó´æ´¢ÔÚÊý¾Ý¿âÖеÄSQL ³ÌÐò¡£
SQLµÄһЩ²éѯÓï¾ä
--1¡¢Áгö¶©µ¥Ã÷ϸ±íÖж©µ¥IDÁÐ±í£¬ÒªÇóÈ¥µôËùÓÐÖظ´Öµ¡£SELECT DISTINCT ¶©µ¥ID FROM ¶©µ¥Ã÷ϸ --2¡¢...
sql³£ÓÃÓï¾äÓÐÄÄЩ?
SQL>SPOOLF:\test\C//µÚ1²½ÏÈÖ¸µ¼´æÈëÎļþ·¾¶SQL>selectempno,ename,job,sal2fromemp3wheresal>=300...
...²¢ÁгöÕâ¸ö²¿ÃÅÔ±¹¤ÊýÁ¿,ÓÃsqlÓï¾äÔõôд
Óï¾ä£º¸Ãsql²éѯµÄÓï¾äÈçÏ£ºSELECT ²¿ÃÅ, Count(²¿ÃÅ) AS Ô±¹¤ÊýÁ¿£¬FROM Ô±¹¤±í£¬GROUP BY ²¿ÃÅ£¬HAVING (((Count(²¿ÃÅ))>3))¡£
ÓÃSQLÓï¾äÁгöÈ«²¿Ñ§Ô±¶¼Ñ¡Ð޵Ŀγ̵ĿγÌÃûºÍ¿Î³ÌºÅ - °Ù...
SELECT CNAME ¿Î³ÌÃû,CNO ¿Î³ÌºÅ FROM C WHERE CNO IN (SELECT CNO FROM SC GROUP BY CNO HAVING COUNT(SNO) =(SELECT COUNT...
SQL Áгö±¾ÔÂÏû·Ñ×î¶àµÄ10λ¿Í»§ Óï¾äÔõôд
select top 10 * from ±í order by Ïû·Ñ desc°´ÕÕÏû·Ñ½µÐòÅÅÁУ¬Ò²¾ÍÊÇÓɸߵ½µÍÅÅ£¬È»ºóÔÙÕÒ³öÇ°10Ìõ¡£
SQLÊý¾Ý¿â³£ÓÃÃüÁî¼°Óï·¨¾ÙÀý
SQL³£ÓÃÃüÁîʹÓ÷½·¨£º(1) Êý¾Ý¼Ç¼ɸѡ£ºsql="select * from Êý¾Ý±í where ×Ö¶ÎÃû=×Ö¶ÎÖµ order by ×Ö¶ÎÃû [desc]"sql="...
SQLÈçºÎÁгö±íÃû
select * from ѧÉú±í¡£¡£¡£ËùÓÐÁÐ select [id], [name] from [sysobjects] where [type] = 'u' order by [name] ËùÓбí...
ÓÃSQLÓïÑÔ,ÁгöºÍ¡®Àî¾ü¡¯Í¬ÐÔ±ðµÄËùÓÐͬѧµÄname - °Ù¶ÈÖª ...
where t2.name = 'Àî¾ü'and t1.sex = t2.sex ÒÔÉϽá¹ûÖÐÒ²°üÀ¨Àî¾ü£¬ÈçÓûÅųý£¬ÔòÔÙ¼ÓÒ»ÐУ¬ÈçÏ£ºand t1.name <> '...