lg4280的个人资料 - RAT

lg4280 lg4280

关注数: 120 粉丝数: 14 发帖数: 136 关注贴吧数: 9

以后泗阳交易就可以在这个地方交易了。老是在泗阳吧被人删帖交易帖太难发了同城交易而已。

PHP操作题 PHP操作题 1、在校友录数据库中增加一个表，表名为“cj”，字段名有学号，数学，英语，将学号设为关键字。 2、建2个动态网页，命名为"cj.php" 和"cj-ht.php",功能为增加学生成绩。 3、要求有页面提交前，对填写学号、数学和英语的文本框进行校对。 4、增加学生成绩完成后，要求页面显示“数据增加成功！” 5、将文件"cj.php"、"cj-ht.php"上传到服务器。

我女朋友总说想我，见我，但是我觉得烦，我是不是不喜欢她了？ RTRT 以前在一起觉得很幸福，但是现在她每天打电话给我，说要来找我，我们是异地恋，我一点都不感动，你们说我是不是不喜欢她了，还要在一起吗？

wow的童鞋们，你们都忘记了魔兽世界了吧、现在各种afk 。大家是不是都忘记了最初的wow 是魔兽呀、

补考试卷，刚从办公室偷的，全班没人会，有人帮看看嘛？ NOTE The following problem sets can serve as the basis for a class project or case. Figure P8.19 Ch08_SaleCo2 Database Tables Use the Ch08_SaleCo2 database to work Problems 19-22. ONLINE CONTENT The Ch08_SaleCo2 database used in Problems 19-22 is located in the Online Student Companion. This database is stored in Microsoft Access format. The Student Online Companion also includes SQL script files (Oracle and SQLServer) for all of the data sets used throughout the book.

正在期末考试，这个什么不会呀，那位哥哥帮做下。看看题目先，。 11. Write a query to produce the number of invoices and the total purchase amounts by customer, using the output shown in Figure P7.25 as your guide. (Compare this summary to the results shown in Problem 24.) FIGURE P7.25 Number of Invoices and Total Purchase Amounts by Customer Note that a query may be used as the data source for another query. The following code is shown in qryP7.25A in your Ch07_Saleco database. Note that the data source is qryP6-24. SELECT CUS_CODE, Count(INV_NUMBER) AS [Number of Invoices], AVG([Invoice Total]) AS [Average Invoice Amount], MAX([Invoice Total]) AS [Max Invoice Amount], MIN([Invoice Total]) AS [Min Invoice Amount], Sum([Invoice Total]) AS [Total Customer Purchases] FROM [qryP7-24] GROUP BY [qryP7-24].CUS_CODE; Instead of using another query as your data source, you can also use an alias. The following code is shown in Oracle format. You can also find the MS Access “alias” version in qryP7.25B in your Ch07_SaleCo database.) SELECT CUS_CODE, COUNT(LINE.INV_NUMBER) AS [Number of Invoices], AVG([Invoice Total]) AS [Average Invoice Amount], MAX([Invoice Total]) AS [Max Invoice Amount], MIN([Invoice Total]) AS [Min Invoice Amount], Sum([Invoice Total]) AS [Total Customer Purchases] FROM (SELECT CUS_CODE, LINE.INV_NUMBER AS INV_NUMBER, Sum(LINE.LINE_UNITS*LINE.LINE_PRICE) AS [Invoice Total] FROM INVOICE, LINE WHERE INVOICE.INV_NUMBER = LINE.INV_NUMBER GROUP BY CUS_CODE, LINE.INV_NUMBER) GROUP BY CUS_CODE; 12. Using the query results in Problem 25 as your basis, write a query to generate the total number of invoices, the invoice total for all of the invoices, the smallest invoice amount, the largest invoice amount, and the average of all of the invoices. (Hint: Check the figure output in Problem 25.) Your output must match Figure P7.26. FIGURE P7.26 Number of Invoices, Invoice Totals, Minimum, Maximum, and Average Sales SELECT Count([qryP7-24].[INV_NUMBER]) AS [Total Invoices], Sum([qryP7-24].[Invoice Total]) AS [Total Sales], Min([qryP7-24].[Invoice Total]) AS [Minimum Sale], Max([qryP7-24].[Invoice Total]) AS [Largest Sale], Avg([qryP7-24].[Invoice Total]) AS [Average Sale] FROM [qryP7-24];

1 下一页