摘要: 83. View the Exhibit and examine the structure of the ORDERS table.You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all thoseorders that were placed after the last order placed by the customer whoseCUSTOMER_ID is 101.Which query would give you the desired output?A. SELECT order_id, orde 阅读全文
posted @ 2013-01-06 15:33 Peyton 阅读(201) 评论(0) 推荐(0) 编辑
摘要: NEXT_DAYThe NEXT_DAY function returns the date of the first instance of a particular day of the week that follows the specified date.SyntaxDescription of the illustration next_day.gifPurposeNEXT_DAYreturns the date of the first weekday named bycharthat is later than the datedate. The return type is 阅读全文
posted @ 2013-01-06 14:38 Peyton 阅读(156) 评论(0) 推荐(0) 编辑