![]() ![]() ![]() WHERE (sales.ord_date = '' /*Last year*/ ) The following displays the revised query: This ensures that your query is valid regardless of the date. With Toad, you simply select Last year to dynamically insert the correct SQL. WHERE (sales.ord_date BETWEEN ' 00:00:00' In the past, you hard coded the dates to create the following statement: You need to create a query that retrieves a list of the orders that were placed last year. If you want to view the syntax of the date range so you can copy it to another application, click the date range link in the Query tab, as illustrated in the following: Note: The date range format is specific to Toad. Identifying the actual date range to use is time consuming, confusing, and is often error prone. When writing a query, you frequently need to retrieve data from a range of dates such as the last week, month, or quarter. Storage Performance and Utilization Management. ![]() Information Archiving & Storage Management.Hybrid Active Directory Security and Governance.Starling Identity Analytics & Risk Intelligence.One Identity Safeguard for Privileged Passwords. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |