AdventureWorks Database: Get the differences between the maximum and minimum orderdate

SQL Query - AdventureWorks: Exercise-115 with Solution

115. From the following table write a query in SQL to find the differences between the maximum and minimum orderdate.

Sample table: Sales.SalesOrderHeader

Click to view Full table

Sample Solution:

SELECT max(OrderDate) - min(OrderDate) FROM Sales.SalesOrderHeader;

Sample Output:

?column? |
1126 days|

SQL AdventureWorks Editor:

Practice Online

Contribute your code and comments through Disqus.

Previous: Get a newdate by adding two days with current date.
Next: Rank the products by the specified inventory locations.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

Follow us on Facebook and Twitter for latest update.