Search - ids - CodeBus

Search - ids - List

[Develop Tools] ids_snort DL : 0: ids snort入侵检测系统的分析与研究博士论文
Date : 2008-10-13 Size : 6.62mb User : 余洋
[Develop Tools] SnortIDS DL : 0: 本书对snort入侵检测原理进行了详细的分析，对研究ids的工作提供有用的参考价值。
Date : 2008-10-13 Size : 11.6mb User : guolimin518
[Develop Tools] eclipse编程附件\jdic-20060613-bin-windows.zip DL : 0: 【SSD7】-EX3答案(queries.sql)2008-08-01 16:48/*1.Display the ID, first name, and joining date of each member whose ID begins with the letters "A%B" or "A&B" and who joined the library no later than Nov. 30, 1997. */ SELECT libid,fname,Join_date FROM MEMBER4 WHERE (libid like 'A\%B%' escape '\' or libid like 'A&B%') and Join_date 1 AND SUM(Qty) > 10 ORDER BY SUM(Qty) ASC /*3.List the IDs and first names of all the members who have read less than 5% of the total number of books read from the library, in non-decreasing order of the number of books read by each.*/ SELECT member4.libid,fname,SUM(TimesRead) AS TotalTimesRead FROM MEMBER4 INNER JOIN READ_BY4 ON MEMBER4.libid = READ_BY4.libid GROUP BY MEMBER4.libid,fname HAVING SUM(TimesRead) 1) ORDER BY fname ASC; /*5.List the names of the suppliers and their respective average quantities of title orders received, whose average quantities of title orders received is more than the average quantity of an order in the system.*/ SELECT SUPPLIER4.name,AVG(Qty) AS Avg_qty FROM SUPPLIER4 INNER JOIN (ORDERED4 INNER JOIN PURCHASE_ORDER4 ON PURCHASE_ORDER4.PoNum = ORDERED4.PoNum) ON SUPPLIER4.Supplier_Id = ORDERED4.Supplier_Id GROUP BY SUPPLIER4.name,ORDERED4.Supplier_Id HAVING AVG(Qty) > (SELECT AVG(Qty) FROM PURCHASE_ORDER4) /*6.List alphabetically the first names and IDs of all the male members of the library who joined before Oct. 10, 1995, who have read only five or fewer different titles, and who have not read the same title twice or more*/ SELECT MEMBER4.fname,MEMBER4.libid,READ_BY4.TimesRead,COUNT (DISTINCT CallNumber) FROM MEMBER4 INNER JOIN READ_BY4 ON MEMBER4.libid = READ_BY4.libid WHERE MEMBER4.Gender = 'M' AND Join_date < '1995-10-10'AND TimesRead < 2 GROUP BY MEMBER4.fname,MEMBER4.libid,READ_BY4.TimesRead HAVING COUNT (DISTINCT CallNumber) <= 5
Date : 2011-03-18 Size : 853.22kb User : c978645312@163.com