¹ØÓÚSQLÁªºÏ²éѯµÄÎÊÌâ
SQL code: select MID,m.HName,md.ToothKind,COUNT(md.ToothKind) as ÊýÁ¿,SUM(md.Price) as ×Ü¼Û from MDetail md left outer join Mechanic m on m.ID=md.MID where MID='1' group by m.HName,md.ToothKind,MID go select count(*) from MDetail where MID='1' ÒÔÉÏÁ½ÌõSQLÓï¾ä£¬ÎªÊ²Ã´µÚÒ»ÌõʹÓÃÁªºÏ²éѯµÃ³öµÄÊýÁ¿½á¹û¸úµÚ¶þÌõÓï¾äµÄ½á¹û²»Ò»ÑùÄØ£¿ÄÇÒªÔõÃ´È¡ÄØ£¿ ============================================================== µÚÒ»Ìõ½á¹û£º MID HName ToothKind ÊýÁ¿ ×Ü¼Û ----------------------------------------- 1 ÖÐÒ½Ôº aaa 96 30912.00 1 ÖÐÒ½Ôº ddd 164 .00 1 ÖÐÒ½Ôº ccc 60 .00 ============================================================== µÚ¶þÌõ½á¹û£º 80 ==============================================================
ÓïÒâ¶¼²»Ò»Ñù°É¡£¡£ÒýÓà ÓïÒâ¶¼²»Ò»Ñù°É¡£¡£ ÎÒ¶¼ÊÇҪȡÊýÁ¿µÄ°¡ ÄÇÎÒÁªºÏ²éѯÄÇÑùд¶Ô²»¶ÔÄØ£¿ µÚÒ»¸öÊǰ´ÕÕ3¸ö·Ö×é ·Ö±ðÇóÊýÁ¿ µÚ2¸ö×Ö×ÜÊýÁ¿ µ±È»²»Ò»Ñù count(distinct md.ToothKind) ÊÔÊÔ ÄãÁª²éµÄ»° Èç¹ûÓÒ±ßÓжàÌõ·ûºÏÌõ¼þµÄ m.ID=md.MIDµÄ»° ½á¹û¼¯ÖоͻáÔö¼ÓÏàÓ¦µÄÐРŶ xiaof˵µÄ¶Ô ÄÇÈç¹ûÎÒҪȡMechanic±íÔÚMDetail±íÖж
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö ÀýÈç procedure produce_proc @p001 nvarchar(8000), @p002 nvarchar(8000), @p003 nvarchar(8000), & ......
»·¾³£º1.win2003server+oracle9i 2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1 3.oracle sql developer°æ±¾ 1.5.5 ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿ ʲôÒâ˼£¿ ¿ÉÒ﵀ 10¸ö¶¼Ã»ÎÊÌâ ¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿ ÀýÈ磺 ALTER PROCEDURE [dbo].[sp_1] @SYS_LNNO varchar(20), @SYS_CALLER varchar(20), @SYS_ORGANIZE varchar(10), ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......